Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line graph showing '0' points
Good afternoon --
I'm creating template workbook into which users will eventually store the last four year's worth of data, and line graphs will depict that data. Some of the users have that much data, but others may only have a year or two to start off with. There are a lot of complicated formulas, so most of the workbook is protected. Right now, if the user has four years of data, the graphs look fine. However, if they have less than that, I've as much as 75% of the graph sitting at zero. I'd MUCH rather have that part of the graph be completely blank, but can't figure out how to do it. The graph gets its source data from a column of calculated cells. I've tried creating 'IF' statements in those cells so that, if there's no data, they're just blank. That hasn't worked. Is there something else I can try? Thanks in advance. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line graph showing '0' points
Hi,
You need to use NA() instead of "" in your formula. IF( <your test , <chart value , NA() ) Cheers Andy pdberger wrote: Good afternoon -- I'm creating template workbook into which users will eventually store the last four year's worth of data, and line graphs will depict that data. Some of the users have that much data, but others may only have a year or two to start off with. There are a lot of complicated formulas, so most of the workbook is protected. Right now, if the user has four years of data, the graphs look fine. However, if they have less than that, I've as much as 75% of the graph sitting at zero. I'd MUCH rather have that part of the graph be completely blank, but can't figure out how to do it. The graph gets its source data from a column of calculated cells. I've tried creating 'IF' statements in those cells so that, if there's no data, they're just blank. That hasn't worked. Is there something else I can try? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding individual points to a line graph | Charts and Charting in Excel | |||
missing data points causes my line graph not to connect | Charts and Charting in Excel | |||
hiding data points on a line graph | Excel Discussion (Misc queries) | |||
Need 2 rows to display X axis data points for a line graph | Charts and Charting in Excel | |||
Automatically adding Vertical lines after certain points in line graph | Charts and Charting in Excel |