Re: Column Charts - stacked and grouped

Here's what Barb was looking for:

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

It provides a few links to sites with good descriptions of clustered/stacked columns. Your first column position in the chart has only one series in the stack, the second has two.

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

Barb R. wrote:

Check out Jon Peltier's site at www.peltiertech.com

I know he has something there on this, but I don't have time to look it up right now.

"jtd1" wrote:


I would like to chart three series. I would like two columns in each group. The first column in a group would be series 1. The second column in a group would be series 2 and 3 stacked on each other. Is that possible? I've come close by using secondary axis but the columns are plotted over each other.

.

Relevant Pages

  • Re: Stacked Chart help needed
    ... Peltier Technical Services ... Even more complicated is I would like to have a label that is based on a point somewhere in the range of the stack. ... The start point mid point and end point I want to display the stacked chart are: ... there are just two stacks in this data plot, ...
    (microsoft.public.excel.charting)
  • Re: chart combinations
    ... stacked column chart with the data in columns A through C. ... the bottom series in the stack, and format it with no borders and no fill to ... with category values in the first column. ... Peltier Technical Services, Inc. - http://PeltierTech.com ...
    (microsoft.public.excel.charting)
  • Re: How to create chart basic
    ... Put X in the first column, ... and create an XY chart or a line chart. ... Peltier Technical Services, Inc. - http://PeltierTech.com ... The x axis may be ...
    (microsoft.public.excel.charting)
  • Re: Triple column stacking chart
    ... The double stack is comprised of two series. ... column and include it in the chart. ... Tutorials and Custom Solutions ... Peltier Technical Services, Inc. - http://PeltierTech.com ...
    (microsoft.public.excel.charting)
  • Re: chart trouble
    ... Srs-a and Srs-b are the series names for the two series, and you are explicitly providing X values for both series in the first column. ... Select this 3x3 range, run the chart wizard, and in step 2, make sure the series are in columns. ... Jon Peltier, Microsoft Excel MVP ... Peltier Technical Services ...
    (microsoft.public.excel.charting)