1 Bar, 2 Line Combination Chart Nightmare - Help!!

G

Guest

Morning,

I have been asked to change a current simple combination chart into a more
complicated one and I'm stuck - big time.

I have 3 series:

1. Cumulative Spend
2. Cumulative Percentage
3. Previous Years Percentage.

I want to have Series 1 as a bar and Series 2 & 3 as lines. I cannot work
this whatsoever. Can anyone help? Please!!!!
 
J

Jon Peltier

Ignore the built-in custom types. Make a line chart with all three sets of
data. Select the chart series you want to change, go to Chart menu > Chart
Type, and select a Column style.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Line Continuation in combination chart 2
Combination Chart- 1 Column, 2 Lines 1
Line Chart & Bar Chart Combined 2
Adding a line to a bar chart 1
How do I alter the number of bar series in a combination chart? 1
100% Stacked Bar chart, two bars, want percent as well as real value 1
Cumulative line on bar chart 1
Creating a Combination Bar Chart with 2 Lines 1

Top