PDA

View Full Version : Data Values in chart



colene
09-29-2008, 11:05 PM
Where i do i specify for a chart to suppress zero values in being displayed in the chart

Bob Phillips
09-30-2008, 01:34 AM
What exactly do you mean by suppress here?

colene
09-30-2008, 02:09 AM
Basically only non zero values be shown in the chart when i set the data values to be

Bob Phillips
09-30-2008, 04:31 AM
Set the Number format of the DataLabels of each series to General;General;

rahullambe
09-30-2008, 07:19 AM
Select Table
go to format cell
number
<custom
paste this
_-* #,##0 _?_-;-* #,##0 _?_-;_-* "-" _?_-;_-@_-

it will work.

Bob Phillips
09-30-2008, 07:25 AM
Select Table
go to format cell
number
<custom
paste this
_-* #,##0 _€_-;-* #,##0 _€_-;_-* "-" _€_-;_-@_-

it will work.

That is better than the 0, but it still shows a little mark in the bars.

colene
10-01-2008, 04:15 AM
Here again my Chart is a seperate sheet and not as object along with the sheet which has the table ..

1.I did try to select each data label in the chart and did Format Data Labels ->Number-> General
....Did not work

2.Also tried Format Data Labels ->Number tab-> Custom->General;General.

....Does nothing .

3.I did try and specify the custom format specified for the cells which has the values like
_-* #.##0 _?_-;-* #.##0_?_-;_-* "-"?? _?_-;_-@_-

bcos i dont want the decimal values ..which case the table cell has _ not zero ..also the chart has _ inlieu of zero..

Is there a way to have zeros in the table only and not in chart ..

Bob Phillips
10-01-2008, 06:02 AM
Post the workbook for us to try it on.

colene
10-01-2008, 10:04 PM
Sorry XlId ,There was a typo error by me
which is a ; at the end ..
Format Data Labels ->Number tab-> Custom->General;General;

Thanks a lot it works now ....

colene
10-01-2008, 10:40 PM
Is it possible to code in VBA as the rows can vary for diffrent projects ()