Chart with un even data

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.



"Abdul" wrote:

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

.

Put one data series on a secondary Y axis
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Abdul" wrote in message
...
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

Hi Bernard,

Could you please explain further from the above examle data.

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

"Abdul" wrote in message
...
Hi Bernard,

Could you please explain further from the above examle data.

thanks

I reckon that doesn't work with the data that has been provided.

"Bernard Liengme" wrote:

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

"Abdul" wrote in message
...
Hi Bernard,

Could you please explain further from the above examle data.

thanks

.

What data was 'provided' ?
Bernard

"trip_to_tokyo" wrote in message
news
I reckon that doesn't work with the data that has been provided.

"Bernard Liengme" wrote:

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

"Abdul" wrote in message
...
Hi Bernard,

Could you please explain further from the above examle data.

thanks

.

See Abdul's original posting.

"Bernard Liengme" wrote:

What data was 'provided' ?
Bernard

"trip_to_tokyo" wrote in message
news
I reckon that doesn't work with the data that has been provided.

"Bernard Liengme" wrote:

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

"Abdul" wrote in message
...
Hi Bernard,

Could you please explain further from the above examle data.

thanks

.

.

Hi,

You could try the broken axis approach.
http://www.andypope.info/charts/brokencolumn.htm

For me your example data produces small but visible column/bars for the
categories C+D.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Abdul" wrote in message
...
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