Home |
Search |
Today's Posts |
#1
|
|||
|
|||
plot chart with no value yet
I want to plot a chart as below:
Jan Feb Mac A 5 8 B 8 6 C 7 7 When the chart is plotted, Mac values is zero instead of blank as I do not have the value yet. When this is in line chart all 3 lines will end at zero value which is not true. |
#2
|
|||
|
|||
Try putting the NA() function in the cells
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "bayanbaru" wrote in message ... I want to plot a chart as below: Jan Feb Mac A 5 8 B 8 6 C 7 7 When the chart is plotted, Mac values is zero instead of blank as I do not have the value yet. When this is in line chart all 3 lines will end at zero value which is not true. |
#3
|
|||
|
|||
Can you give me an example.
"Nick Hodge" wrote: Try putting the NA() function in the cells -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "bayanbaru" wrote in message ... I want to plot a chart as below: Jan Feb Mac A 5 8 B 8 6 C 7 7 When the chart is plotted, Mac values is zero instead of blank as I do not have the value yet. When this is in line chart all 3 lines will end at zero value which is not true. |
#4
|
|||
|
|||
You probably have a formula that contains a zero-length string, i.e.,
"", in it. Replace the "" with NA() If you don't (and the cells are truly empty, i.e., =ISBLANK({cell}) returns TRUE), you should select the chart, then select Tools | Options... | Chart. In there change the 'Plot empty cells as' option to something other than 'zero'. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Can you give me an example. "Nick Hodge" wrote: Try putting the NA() function in the cells -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "bayanbaru" wrote in message ... I want to plot a chart as below: Jan Feb Mac A 5 8 B 8 6 C 7 7 When the chart is plotted, Mac values is zero instead of blank as I do not have the value yet. When this is in line chart all 3 lines will end at zero value which is not true. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I alter plot area colour in a chart without a mouse? | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Setting custom chart causes plot area to collapse | Charts and Charting in Excel | |||
Strange Problem with Chart and Plot Visible Cells Option | Charts and Charting in Excel | |||
BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) |