Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Zero value and bar graph
Hello all,
I'm new to graphs and what I have is a date range (1-Jan-08 - 31-Jan-08) with a dollor amount in the next cell. The bar graph is picking up the "zero" or blank ("")cells and is ploting them on the graph. How can I have the graph not plot the "zero" or blank ("") values? I did the flowing to the amounts:=IF(N18=0,NA(),N18) and that remove the "$0" from the graph, but it's still pickup the dates. Off2000 Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Zero value and bar graph
Hi,
The NA() trick only suppressed the point/bar/column. It does not remove the point from the series. To do that you can hide the row using autofilter and as long as the chart is set to Plot only visible cells the point should be removed. If the chart object is in the same rows as the data you will need to unset the Move and size properties of the chartobject otherwise it will change size. Cheers Andy pgarcia wrote: Hello all, I'm new to graphs and what I have is a date range (1-Jan-08 - 31-Jan-08) with a dollor amount in the next cell. The bar graph is picking up the "zero" or blank ("")cells and is ploting them on the graph. How can I have the graph not plot the "zero" or blank ("") values? I did the flowing to the amounts:=IF(N18=0,NA(),N18) and that remove the "$0" from the graph, but it's still pickup the dates. Off2000 Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Can I make a graph to be a specific size? (actual graph) | Excel Discussion (Misc queries) | |||
Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel |