Home |
Search |
Today's Posts |
#1
|
|||
|
|||
suppress zero values in line charts?
How can I suppress the plotting of zero values in line charts? The source
cells have a formula that evaluates as zero for future dates in the date range. |
#2
|
|||
|
|||
Rather than getting the formula to evaluate to zero, get it to evaluate to
the N/A# error =IF(Date<Today,NA(),Value) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Cruickshank Brothers" <Cruickshank wrote in message ... How can I suppress the plotting of zero values in line charts? The source cells have a formula that evaluates as zero for future dates in the date range. |
#3
|
|||
|
|||
In addition to Nick's suggestion check
Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , "=? Utf-8?B?Q3J1aWNrc2hhbmsgQnJvdGhlcnM=?=" <Cruickshank says... How can I suppress the plotting of zero values in line charts? The source cells have a formula that evaluates as zero for future dates in the date range. |
#4
|
|||
|
|||
How do I suppress zero values in a pie chart. i have tried returning na# instead of zero and I tried using the format General; General, neither are working for me with pie charts.... the na# appears, and when I use General; General a dash "-" appears. By way of explanation - I have a list of customers with a contribution% against each - i wish to show the postive % customers on one pie chart, and the negative % csutomers on a second pie chart. i have therefore created two new % values and used an IF statement to supress postives on one and negatives on the other. From that I make two graphs... -- Kevin Gallagher ------------------------------------------------------------------------ Kevin Gallagher's Profile: http://www.excelforum.com/member.php...fo&userid=7459 View this thread: http://www.excelforum.com/showthread...hreadid=335716 |
#5
|
|||
|
|||
Kevin -
The NA() trick to get #N/A in a cell doesn't help with pie charts. You almost got it with the number formats, but you only specified positive and negative number formats. You need to add two semicolons: General;General;; The lack of anything between the last two semicolons tells Excel not to show zeros. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Kevin Gallagher wrote: How do I suppress zero values in a pie chart. i have tried returning na# instead of zero and I tried using the format General; General, neither are working for me with pie charts.... the na# appears, and when I use General; General a dash "-" appears. By way of explanation - I have a list of customers with a contribution% against each - i wish to show the postive % customers on one pie chart, and the negative % csutomers on a second pie chart. i have therefore created two new % values and used an IF statement to supress postives on one and negatives on the other. From that I make two graphs... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line graphs with null values | Charts and Charting in Excel | |||
Gappy data in line charts? | Charts and Charting in Excel | |||
How do I add a reference line to Excel charts? | Charts and Charting in Excel | |||
To get a lot of charts that contain different values in a minute | Charts and Charting in Excel | |||
How to force continuous lines in line charts | Charts and Charting in Excel |