Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Aurora
 
Posts: n/a
Default 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 Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bar Chart To Line Chart for last 3 points only Big H Charts and Charting in Excel 1 October 13th 05 09:55 PM
tick mark labels Debrane Charts and Charting in Excel 9 July 19th 05 02:53 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Line chart in Excel - trendline incomplete [email protected] Charts and Charting in Excel 7 May 13th 05 01:21 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM


All times are GMT +1. The time now is 06:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"