Thread: Charts comparing data

Anyone can help me with this ?

I need to create a chart displaying comparison data, for example :

In a project we spend 10 days doing planning, 15 days development n 3 days
discussion. I need to combine these details and compare it against our
planned days of may be 30.

Can this be done ?

Make a stacked bar chart. Set up your data like this (use a fixed width font
to view this):

Blank Plan Devel Discuss
x 0 0 0 0
x 0 10
Planned 10 15
x 25 5
x 0 0 0 0
x 0 11
Actual 11 13
x 24 3
x 0 0 0 0

The top left cell should be blank. The cells containing "x" will be cleared
after the chart is made.

Select the whole data range and create a chart. Choose the stacked
horizontal bar chart in step one. Then hit finish because the defaults are
fine.

Double click the category axis (the left hand vertical axis). On the scale
tab, check the Categories in Reverse Order and Value (Y) Axis Crosses at
Maximum Category boxes.

Double click on the Blank series in the chart. On the options tab, change
Gap Width to zero, and on the Patterns tab, choose None for Border and Area.

Format the rest of the chart the way you like it, then go back to the data,
and clear the cells with the temporary "x" values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Desmond" <Desmond@discussions.microsoft.com> wrote in message
news:6582258C-724F-4261-8A56-3C873987A741@microsoft.com...
> Anyone can help me with this ?
>
> I need to create a chart displaying comparison data, for example :
>
> In a project we spend 10 days doing planning, 15 days development n 3 days
> discussion. I need to combine these details and compare it against our
> planned days of may be 30.
>
> Can this be done ?

An alternative version of the chart differs only in the initial data
configuration:

Blank Plan Develop Discuss
x x 0 0 0 0
Planned Plan 0 10
Develop 10 15
Discuss 25 5
x x 0 0 0 0
Actual Plan 0 11
Develop 11 13
Discuss 24 3
x x 0 0 0 0

The first two cells in the top row are blank, as are the two cells below
"Planned" and the two cells below "Actual". Follow the same procedures, and
you will get a chart with two sets of labels along the left side of the
chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Jon Peltier" <jonxlmvpREMOVE@CAPSpeltiertech.com> wrote in message
news:uaGwZEkAGHA.2156@TK2MSFTNGP11.phx.gbl...
> Make a stacked bar chart. Set up your data like this (use a fixed width
> font to view this):
>
> Blank Plan Devel Discuss
> x 0 0 0 0
> x 0 10
> Planned 10 15
> x 25 5
> x 0 0 0 0
> x 0 11
> Actual 11 13
> x 24 3
> x 0 0 0 0
>
> The top left cell should be blank. The cells containing "x" will be
> cleared after the chart is made.
>
> Select the whole data range and create a chart. Choose the stacked
> horizontal bar chart in step one. Then hit finish because the defaults are
> fine.
>
> Double click the category axis (the left hand vertical axis). On the scale
> tab, check the Categories in Reverse Order and Value (Y) Axis Crosses at
> Maximum Category boxes.
>
> Double click on the Blank series in the chart. On the options tab, change
> Gap Width to zero, and on the Patterns tab, choose None for Border and
> Area.
>
> Format the rest of the chart the way you like it, then go back to the
> data, and clear the cells with the temporary "x" values.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> "Desmond" <Desmond@discussions.microsoft.com> wrote in message
> news:6582258C-724F-4261-8A56-3C873987A741@microsoft.com...
>> Anyone can help me with this ?
>>
>> I need to create a chart displaying comparison data, for example :
>>
>> In a project we spend 10 days doing planning, 15 days development n 3
>> days
>> discussion. I need to combine these details and compare it against our
>> planned days of may be 30.
>>
>> Can this be done ?
>
>