Chart with un even data

  • Thread starter Thread starter Abdul
  • Start date Start date
A

Abdul

Hi,

I have to plot budget performance of different units in a chart. The
issue is that one of the unit is in miilons ( big figures while the
other units is in thousands (small amounts) If i sekect the proper
scale in a bar chart one of them is too small to be visible. I tried
to use logarthmatic scale, but it is not giving a clear picture. Like
when the achievement for the smaller figured bar chart portion is 50 %
the chart look like something like 90 %.

Is there a better way to present this? or use different scale for the
data for different bar?

My dat look like this

Category Budget Actual
A 365,000,000 395,000,000
B 207,000,000 275,000,000
C 10,000,000 5,000,000
D 4,000,000 6,000,000

Hoe can I present this in a bar chart ?

Thanks
 
One possible solution is to put your chart into Landscape format and then
drag the chart out as far as possible to the right hand side. If you do this
the, "lower" numbers are clearly visible.

Please hit Yes if my comments have helped.

Thanks.
 
Right click one data series on the chart and select Format Data Series
Depending on what version of Excel you are using there will be an option
somewhere to use a secondary axis for this data series.
The secondary axis will be on the right-hand side of the chart and will
automatically get a suitable (or near suitable) scale.
best wishes
Bernard
 
Back
Top