LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 33
Default Excel chart categories....

Assume you have a data of 12 lines that time sensitive due to the
dates they would be filled. Each line would be a number for that
month.

I get the whole, adding NA() to remove the zero so that it does not
plot. However, I wanted to take it a step further...

Currently, the graph will plot up to the month you are in. Let's
assume it is June. As for the X-axis it shows from January to
December, but the graph does not plot anything after June due to the
NA() function to remove any zero values.

If you have 12 lines to signify each month, is it possible so that the
categories seen on the X axis as well as what is plotted, to only show
from January to June instead of January to Decemeber but stops
plotting at June?
 
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
column chart with 3 categories martymi Charts and Charting in Excel 2 May 1st 07 07:29 PM
Bar chart with Y Axes Categories MB Charts and Charting in Excel 6 February 20th 07 09:58 PM
Chart Categories SJT Excel Discussion (Misc queries) 1 June 19th 06 08:13 PM
3D chart categories elementary Charts and Charting in Excel 0 May 22nd 06 06:59 PM
Badly need help to put four categories in one pie chart shadow_3211 Charts and Charting in Excel 2 November 14th 05 03:03 PM


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