Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Column Charts
I am looking at trying to create a dual column chart which contains 8 sets of
data, four of which are for plan data and four are for the actual data. Is it possible to create two combined columns, one for each set of data on the one graph. I cannot find any information to achieve this. Can anyone help. Thanks Ray |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Column Charts
One approach would be to plot two series, one for plan, the other for
actual. Data: Plan Actual A [data] [data] B [data] [data] C [data] [data] D [data] [data] Select the range, create a clustered column chart. Each cluster will have two columns, plan and actual, and each of the labels in the first column (I used A, B, C, D) will be centered under one of these pairs. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ray Clark" wrote in message ... I am looking at trying to create a dual column chart which contains 8 sets of data, four of which are for plan data and four are for the actual data. Is it possible to create two combined columns, one for each set of data on the one graph. I cannot find any information to achieve this. Can anyone help. Thanks Ray |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Column Charts
Jon,
Thanks for your reply but I may not have included details in my question. This is the data layout:- Date Plan Plan Plan Plan Actual Actual Actual Actual Mat. A Mat B Mat C Mat D Mat A Mat B Mat C Mat D Jan-07 [data] [data] [data] [data] [data] [data] [data] [data] Feb-07 [data] [data] [data] [data] [data] [data] [data] [data] etc to Jan-08 Currently there is 13 months of data for each one which will eventually become 18 lines and if possible would be good to cluster the plan numbers for each year and also the actual data. Do you know if this is possible. Thanks Ray "Jon Peltier" wrote: One approach would be to plot two series, one for plan, the other for actual. Data: Plan Actual A [data] [data] B [data] [data] C [data] [data] D [data] [data] Select the range, create a clustered column chart. Each cluster will have two columns, plan and actual, and each of the labels in the first column (I used A, B, C, D) will be centered under one of these pairs. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ray Clark" wrote in message ... I am looking at trying to create a dual column chart which contains 8 sets of data, four of which are for plan data and four are for the actual data. Is it possible to create two combined columns, one for each set of data on the one graph. I cannot find any information to achieve this. Can anyone help. Thanks Ray |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Column Charts
This is a lot of data points, eight per date or 36 per Mat (18 months plan
and 18 months actual). It may make sense to simplify or separate the data. and to think about what you want the reader to come away with. Do you need to compare among Mat A through Mat B, or is it more important to keep the timelines for each Mat together? Also, if the category axis consists of dates, it's common practice to use a line chart instead of a column chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ray Clark" wrote in message ... Jon, Thanks for your reply but I may not have included details in my question. This is the data layout:- Date Plan Plan Plan Plan Actual Actual Actual Actual Mat. A Mat B Mat C Mat D Mat A Mat B Mat C Mat D Jan-07 [data] [data] [data] [data] [data] [data] [data] [data] Feb-07 [data] [data] [data] [data] [data] [data] [data] [data] etc to Jan-08 Currently there is 13 months of data for each one which will eventually become 18 lines and if possible would be good to cluster the plan numbers for each year and also the actual data. Do you know if this is possible. Thanks Ray "Jon Peltier" wrote: One approach would be to plot two series, one for plan, the other for actual. Data: Plan Actual A [data] [data] B [data] [data] C [data] [data] D [data] [data] Select the range, create a clustered column chart. Each cluster will have two columns, plan and actual, and each of the labels in the first column (I used A, B, C, D) will be centered under one of these pairs. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ray Clark" wrote in message ... I am looking at trying to create a dual column chart which contains 8 sets of data, four of which are for plan data and four are for the actual data. Is it possible to create two combined columns, one for each set of data on the one graph. I cannot find any information to achieve this. Can anyone help. Thanks Ray |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Column Charts
Jon,
Thanks for your input looks like I will need to work this differently. Thanks Ray "Jon Peltier" wrote: This is a lot of data points, eight per date or 36 per Mat (18 months plan and 18 months actual). It may make sense to simplify or separate the data. and to think about what you want the reader to come away with. Do you need to compare among Mat A through Mat B, or is it more important to keep the timelines for each Mat together? Also, if the category axis consists of dates, it's common practice to use a line chart instead of a column chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ray Clark" wrote in message ... Jon, Thanks for your reply but I may not have included details in my question. This is the data layout:- Date Plan Plan Plan Plan Actual Actual Actual Actual Mat. A Mat B Mat C Mat D Mat A Mat B Mat C Mat D Jan-07 [data] [data] [data] [data] [data] [data] [data] [data] Feb-07 [data] [data] [data] [data] [data] [data] [data] [data] etc to Jan-08 Currently there is 13 months of data for each one which will eventually become 18 lines and if possible would be good to cluster the plan numbers for each year and also the actual data. Do you know if this is possible. Thanks Ray "Jon Peltier" wrote: One approach would be to plot two series, one for plan, the other for actual. Data: Plan Actual A [data] [data] B [data] [data] C [data] [data] D [data] [data] Select the range, create a clustered column chart. Each cluster will have two columns, plan and actual, and each of the labels in the first column (I used A, B, C, D) will be centered under one of these pairs. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ray Clark" wrote in message ... I am looking at trying to create a dual column chart which contains 8 sets of data, four of which are for plan data and four are for the actual data. Is it possible to create two combined columns, one for each set of data on the one graph. I cannot find any information to achieve this. Can anyone help. Thanks Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill bar/column charts with patterns in Excel 2007? | Charts and Charting in Excel | |||
Excel 2007 - percentage and values on 100% line/column stacked charts | Charts and Charting in Excel | |||
Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
problem with column charts and two Y axes in Excel 2003 | Charts and Charting in Excel |