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" <(E-Mail Removed)> wrote in message
news:efb972e5-bdd8-487f-b80f-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:81124a23-2b62-4760-8c7d-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:81124a23-2b62-4760-8c7d-(E-Mail Removed)...
> > Hi Bernard,
> >
> > Could you please explain further from the above examle data.
> >
> > thanks
> >
> .
>

What data was 'provided' ?
Bernard

"trip_to_tokyo" <(E-Mail Removed)> wrote in message
news9D1AB54-7CB9-40AF-8AF2-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:81124a23-2b62-4760-8c7d-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
> news9D1AB54-7CB9-40AF-8AF2-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:81124a23-2b62-4760-8c7d-(E-Mail Removed)...
> >> > 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" <(E-Mail Removed)> wrote in message
news:efb972e5-bdd8-487f-b80f-(E-Mail Removed)...
> 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
>