| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
In bar chart using values-NOT show the value of zero
Or use a number format without an entry for zero:
General;General;;@ 0.00;0.00;;@ 0%;0%;;@ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bernard Liengme" wrote in message ... I take it you mean you are using values as data labels but do not want 0 to be displayed. Right click the Data Labels in chart; use Format Data Labels Use a Custom Format of General; General; [White]General and set the font background to transparent Change [White] to whatever colour you use for the plot area so the 0 is invisible best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Harry" wrote in message ... Each bar in chart shows a value. I do NOT want the value of ZERO to show. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i show non-numeric values graphically in a chart? | Charts and Charting in Excel | |||
| how can I show repeating values in a chart? | Charts and Charting in Excel | |||
| How do I show values of data points in a chart with the mouse poin | Charts and Charting in Excel | |||
| Chart problem: values in column A doen't show on x-axis | Excel Discussion (Misc queries) | |||
| How can I get the zero values at the end of a chart not to show? | Charts and Charting in Excel | |||
Threaded Mode
