Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked bar charts of plan versus actual
Is there an FAQ that tells me how I can create month-by-month stacked bar
charts of plan versus actual? I need to plot a set of products (plan versus actual), and each month I would have an additional pair of stacked bars. Thank you. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked bar charts of plan versus actual
You don't want stacked, because that would add actual to plan. make a
clustered (side-by-side) column chart. To get a chart that shows a better trend than clustered columns, keep the clustered column type, but format the plan columns with a border and no fill, and the actual columns with a fill and no border, plot the actual series first and the plan second *change the plot order), and change the overlap of these series to 100%. The plot may look similar to the one at http://peltiertech.com/WordPress/wp-...g/MFhisto2.png - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "avathaar" wrote in message ... Is there an FAQ that tells me how I can create month-by-month stacked bar charts of plan versus actual? I need to plot a set of products (plan versus actual), and each month I would have an additional pair of stacked bars. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Actual vs Budgeted - Stacked Bar Chart | Charts and Charting in Excel | |||
Check plan versus complete | Excel Worksheet Functions | |||
interactive charts for stacked bar charts | Charts and Charting in Excel | |||
Need to graph weekly shipments of 3 classes of freight versus plan | Charts and Charting in Excel | |||
Stacked Bar Charts | Excel Worksheet Functions |