| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Zero's
Hi
I have created a Bar graph to show timings on a job, my problem is I have linked them to another page so when I have a sum formula the bar chart shows Zeros.. can I stop this happening? Much Appreciated Kev |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Zero's
In your link formula, put in something like
=IF(Sheet1!A1=0,"",Sheet1!A1) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bar Charts With =sum ... showing Zero" <Bar Charts With =sum ... showing wrote in message ... Hi I have created a Bar graph to show timings on a job, my problem is I have linked them to another page so when I have a sum formula the bar chart shows Zeros.. can I stop this happening? Much Appreciated Kev |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help replacing dropped zeros | Excel Discussion (Misc queries) | |||
| Keep Lead Zeros | Excel Discussion (Misc queries) | |||
| Leading Zeros | Excel Discussion (Misc queries) | |||
| Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
Linear Mode
