Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aurora
 
Posts: n/a
Default LINE CHARTS

I am new to Excel 2003

This is a second posting. The first ans I got did not help me at all.

I have a line chart for the year - Jan thru Dec. Right now the chart only
contains data for Jan thru April. Then the line goes down to the bottom of
the chart (to May - zero data point). I call this the "tail". I know it is
there because I do not have any data in May-Dec yet. But I want to get rid
of the tail. On Excel 2000, I was able to right click, near the data point,
and choose "no line" and the "tail" went away. Now when I do this, either all
of the lines between the points disappear or the tail jumps to the next month
(June).

How do I get rid of the tail? I know I could limit the source data
to just the months I have data in, but I really do not want to go back into
the charts every month and re-set the source data each month. I have about
20 charts with anywhere from 2 - 6 lines on each chart. To do this would be
a real pain.

Can anyone help me or point me in the right direction? I need to complete
these charts ASAP.

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
How do I hide 0 values in line charts Stephan Charts and Charting in Excel 5 August 12th 09 03:07 PM
LINE CHARTS Aurora Charts and Charting in Excel 1 May 9th 06 05:05 PM
Let me use the Line Color icon on charts Stuart Bratesman Charts and Charting in Excel 0 January 6th 06 03:40 PM
Charts Line Types for Multiple Data Series not Printing Properly Seanb Charts and Charting in Excel 0 August 22nd 05 06:35 PM
How to force continuous lines in line charts wal50 Charts and Charting in Excel 1 December 21st 04 10:43 PM


All times are GMT +1. The time now is 09:36 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"