Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts comparing data
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" wrote in message ... 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 ? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts comparing data
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" wrote in message ... 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" wrote in message ... 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Charts based on data in Table | Charts and Charting in Excel | |||
irritating warning for negative data on log charts | Charts and Charting in Excel | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Comparing data in two columns and highlighting the data | Excel Worksheet Functions |