5

So I have a bunch of series laid out like this in excel: chart data

I'd like to have them plotted all on one column chart but with the series separated (i.e. not clustered) so it basically is several column charts stuck together that share the same y-axis.

Like this but combined only one actual chart: chart

Is such a thing possible?

7

It is very easy to make a chart like this in Excel. You'll just need to change your data layout.

  1. List all of your category labels are in a single column.
  2. Create a column for each category type (e.g. equities, corporate, sovreign...)
  3. For each category, just place the value in the appropriate categories column. Your data should look something like this:

    Data Layout

  4. Then, create a Clustered Column Chart Insert>Column>Clustered Column.

  5. Select your data series, then Format>Series Option>Series Overlap and set the value to 100%.
  6. Format to taste (e.g. move horizontal axis to low, remove grid lines, adjust percentage decimals to 0, etc...)

Your completed chart should look something like this:

MultiColumn

FWIW, I'd consider a Bar Chart laid out in similar fashion (just insert Clustered Bar instead of Clustered Column). Cleaned up a bit, it would make your category labels easier to read (horizontal, rather than vertical) and can be compressed a bit easier into a smaller space.

MultiBar

  • 1
    Nicely answered. – CharlieRB Jun 6 '13 at 12:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.