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

D

Darren McMillan

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

Convert Error Bars to Series and Colour 1
Overlay line graph points on bar graph 1
Move bar chart to behind lines 0
Line Chart & Bar Chart Combined 2
Chart SERIES OFFSET 5
sideways stacked bar charts with line series on the same axis 0
Combining a 2-D column graph and a 2-D line graph on the same char 3
Chart with columns and lines 1

Top