Re: Double stacked columns - can it be done?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

So you would like a clustered-stacked column chart? Excel doesn't do this type of chart natively, but with a little clever arrangement of the data you can make a stacked chart look the way you want. This page links to a handful of examples:

  http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

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


Mark wrote: 
I need 2 stacked columns side by side for each month.

Here is the data for October:
Forecast Credits	200
Forecast Cash		50
Actual Credits		220
Actual Cash		55
Total Forecast		250
Total Actual		275

One column is forecast; the other is actual.
I would then need a line plotted on the secondary axis for Total Actual.

Can it be done? 
.

Relevant Pages

  • Re: #N/A Values : Returned by Formulas vs Entered Manually
    ... Hold down CTRL-SHIFT while pressing Enter, and if it's done properly, Excel drawns them for you. ... Peltier Technical Services ... This is the column where I want the chart line stopped if there is no numerical value from the previous formula. ... But if the #N/A values are manually entered into those same cells, ...
    (microsoft.public.excel.charting)
  • Re: Update "buildin" excel in a powerpoint with macro
    ... tried to run the macro manualy with the tool>macro>run updategraph. ... make a simple chart in an Excel workbook ... Switch to a new empty PowerPoint presentation ... Switch back to Excel and quit Excel ...
    (microsoft.public.mac.office.powerpoint)
  • Re: Update "buildin" excel in a powerpoint with macro
    ... Problem #2 - How to get the macro to run more than a single time. ... make a simple chart in an Excel workbook ... Switch to a new empty PowerPoint presentation ... Switch back to Excel and quit Excel ...
    (microsoft.public.mac.office.powerpoint)
  • Re: Publishing a chart to a web page
    ... This code works as is for any version of Excel since '97, ... rerun the macro with that statement in itto export new pictures of the chart. ... Jon Peltier, Microsoft Excel MVP ... Peltier Technical Services ...
    (microsoft.public.excel.charting)
  • Re: Update "buildin" excel in a powerpoint with macro
    ... Problem #2 - How to get the macro to run more than a single time. ... make a simple chart in an Excel workbook ... Switch to a new empty PowerPoint presentation ... Switch back to Excel and quit Excel ...
    (microsoft.public.mac.office.powerpoint)