Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
column chart with 3 categories | Charts and Charting in Excel | |||
Bar chart with Y Axes Categories | Charts and Charting in Excel | |||
Chart Categories | Excel Discussion (Misc queries) | |||
3D chart categories | Charts and Charting in Excel | |||
Badly need help to put four categories in one pie chart | Charts and Charting in Excel |