Chart with un even data

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
 
T

trip_to_tokyo

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.
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem w/X axis in chart (2003) 3
waterfall chart 1
2 scale in a single chart 1
how do i create a chart with 4 sets of data? 3
Resize chart and preserve formatting (Excel 2007) 3
Problem with my Chart Template 0
Stacked Bar Chart with Secondary Axis 7
How do I show percentage data with the % sign on a bar chart? 1

Top