If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Line Chart
I am using Excel 2000.
I have a line chart that charts 4 sets of data, by month, for 1 year. I am using the 4th type sub chart type of line chart. My data points are OK except for the last point which is always down at "0" - the bottom of my chart. This causes, what I call a tail to hang down from the previous point to the bottom of my chart. I understand why this happens because there is no data for the next point. But I do not like the "tail" hanging down. If I only hi-lite the cells that have data, my chart looks like it only has 2 or 3 months. I can not keep all of the 12 months on the chart. Can anyone help me? Am I using the wrong line chart for this type of chart. I know I have had problems before with charts - if I have picked the wrong kind of chart. But I really do not understand the difference in the line sub charts. Can anyone help me????? I certainly would appreciate and help or at least point me in the right direction. I have about 10 different charts that this happens to. Aurora |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Line chart from multiple worksheets | Paul B. | Charts and Charting | 2 | September 21st, 2005 11:46 PM |
Creating a line chart with two X-axes!! | JaVaughn | General Discussion | 1 | June 30th, 2005 01:36 PM |
Line chart - date line association gone mad! | Johannes Czernin | Charts and Charting | 5 | January 17th, 2005 08:48 PM |
Trying To Add a Line to an Excel chart using variable cell values | Larry Campbell | Charts and Charting | 2 | January 24th, 2004 05:31 PM |
Plotting a datapoint on an existing Line chart | Tushar Mehta | Charts and Charting | 0 | November 23rd, 2003 01:08 AM |