| Thread | Last Post | Replies |
|
| Date Scaling Issue | 19 Mar 2006 18:06 GMT | 1 |
I have created an x-y scatter chart that has dates along the x-axis (mm/dd/yy). The first date on the chart does not correspond to the first date in my source data! When I go to change the min scale for the x-axis instead of seeing a starting date I see a huge number(38790) that ...
|
| Dynamic Chart | 19 Mar 2006 16:13 GMT | 2 |
I have a spreadsheet that has its data in the following format: 2003 2004 2005 2006 Company 1 1.5 1.63 2.1 Company 2 .75 .89 1.09
|
| How to get excel to recognise "infinity" for asymptotes in charts | 19 Mar 2006 13:53 GMT | 2 |
I'm trying to make various graphs based on the function "y = tan(x)" for revision purposes. The only problem is that the graph contains an asymptote: a dotted line parallel to the y-axis that the plot-line approaches but never quite reaches. Excel doesn't seem to recognise this ...
|
| Line chart with multiple scales/units along an axis... | 19 Mar 2006 05:53 GMT | 3 |
I have a rather complex chart that I need to create... hopefully someone here can help me with this issue... The problem is the following: I have offers from vendors for two types of cables that I want to
|
| large project | 19 Mar 2006 00:00 GMT | 1 |
I have 18 projects that each have 39 jobs but only need this information for meetings. I need a spreadsheet where the info won't get lost or seem overwhelming. Any ideas
|
| Distorted Excel chart fonts when copy/paste to Word or Powerpoint | 18 Mar 2006 19:43 GMT | 2 |
Since a few weeks I'm having a problem with Excel charts. First of all, the y-axis title is cut-off after 6-7 characters on the display screen, although it prints correctly. Second, when I copy and paste the chart into e.g. Word or Powerpoint the
|
| IN EXCEL, HOW CAN I OFSET THE LINE OF ORIGIN SOME IT RUNS THROUGH | 18 Mar 2006 01:12 GMT | 1 |
i am trying to move a line on the graph in excel so that it runs through the orgin
|
| using multipe source data to plot on one chart | 17 Mar 2006 23:52 GMT | 1 |
I have monthly data across several years. I want to chart SOME of the months. The monthly data are in two different excel files. Can I create a chart using some source data from one file and other source data from a second file? IF the answer is that I have to use a pivot ...
|
| How do I create multiple pivot charts from one pivot table? | 17 Mar 2006 23:01 GMT | 1 |
When I create the second pivot chart, and manipulate fields, the original pivot chart also reflects the changes I make to the second???
|
| Dynamic Charts Offset | 17 Mar 2006 20:37 GMT | 4 |
Please help. I have read other posts but my situation is a bit different and I am having trouble adapting the suggestions to my situation. I am creating a bar chart that shows per contract the estimated hours and the actual hours. CUrrently, I have contracts that have no ...
|
| Boxplots with outliers | 17 Mar 2006 20:36 GMT | 1 |
I'm doing this assignment for Maths and I need to do parallel boxplots. I know how to do them on Excel, but one of the boxplots has outliers and I MUST plot them in, but I have no idea how to do that. I was hoping that someone would be able to tell or show me how to do that.
|
| How can I get headers to copy in charts? | 17 Mar 2006 20:33 GMT | 1 |
I made one imbedded chart, then copied it to make a similatrsecond chart; however, the header and footer from the first chart did not carry over to the second chart. How can I avoid redoing the headers and footers in copied charts?
|
| Create Array for Data Source | 17 Mar 2006 20:31 GMT | 1 |
I'm trying to create a goal or target line that displays on a line chart. In the past, I would create an additional row in my spreadsheet and enter the goal number (say, 80%) in every column. I've noticed in some chart examples a source data range that looks like {.80,.80,.80}.
|
| XY Scatter doesn't display correctly when data has numbers&empty c | 17 Mar 2006 17:38 GMT | 2 |
The source data is in columns A (for Y values) and B (for X values). Say A1 through A10 have {6.53, 6.41, 5.89, empty cell, empty cell, empty cell, empty cell, 6.74, 7.00, 6.50} and B1 through B10 have {7.19, 6.92, 6.74, 6.17, 6.34, 6.57, 6.47, 6.88, 7.12, 6.76}. NOTE that the ...
|
| Any way to build one stacked bar chart for three groups of data? | 17 Mar 2006 04:17 GMT | 2 |
I have three groups of data made of several cells of data each and would like to represent them on one chart. I would like to have each group represented as a separate stacked column so I can see the individual columns for each cell within the group and still see the ...
|