Line disappears from combination chart

S

Shevvie

created bar and line chart - after they are in place, I add a secondary axis
which makes the line disappear (however, the series is still included in the
range)?
Thanks
 
S

ShaneDevenshire

Hi Shevvie,

I'm not sure what is going on but try this - instead of creating the chart
and then adding a secondary axis, select your data and click the chart
wizard, choose the Custom Types tab and then Line - Column on 2 Axes.
Complete the chart.
 

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

Chart data scrunches to left when adding X axis date series 0
Custom Format numbers for learning chart 0
sideways stacked bar charts with line series on the same axis 0
Adding a line to a population bar chart 0
Gantt chart duration not showing 0
multiple series bar and line chart 2
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 1
One extra x axis item that wont go away - can anyone help? 3

Top