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
When I create Line Charts - usually for a year's time frame, my last part of
the line (tail) on the chart goes directly to the bottom of the chart. For
example: My line goes up and down for jan, feb, mar, (per the data) but
because there is no data for apr, the line goes directly to the bottom of the
graph (0) at apr. I understand why this happens, but someone told me there
is a way to stop this line at the end of the data without the tail hanging
down. I know that I could just highlight just the cells with data. but this
in turn stretches my time frame (jan,feb& mar) across the whole chart
instead of showing the whole year (jan - dec). Does anyone know how to get
rid of just the tail on the chart? I know this is a small thing, but it bugs
some people around here. I would certainly appreciate any help someone can
give me.

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:08 PM.

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"