• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

excel 2007 graph

Good Afternoon,

Have a monthly graph that I would like for the future months (MAR-DEC 2011) not to reflect "0" on the graph but just to show the months that have data (jan-feb).  Not sure if there is a formula that would do this instead of what I have curretnly (SUM) in column B11:B22.  I have attached an example.
EXAMPLE.xlsx
0
nmolliconi
Asked:
nmolliconi
  • 3
1 Solution
 
jppintoCommented:
Please take a look at my article about "Hide Zeros":

http://excel-user.blogspot.com/2010/01/excel-charts-hide-zeros.html

jppinto
0
 
jppintoCommented:
Change the SUM formula to something like this:

=IF(SUM(C3:C9)=0,NA(),SUM(C3:C9))

This will display #N/A instead of 0's and will not plot on your chart.

jppinto
0
 
jppintoCommented:
Please check a working example on the attached file.

jppinto
Example.xlsx
0
 
nmolliconiAuthor Commented:
Thank you!
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now