Can you create a chart with columns and lines along the xaxis?

N

Nadia

I am trying to create a chart with time along the x axis (2x years and then 4
weekly periods for 1 year). I would like the 2x years to be bars and the 4
weekly periods to be lines. I created a line chart and tried highlighting
single data points and changing to chart type column but it only changes the
whole series. Is it possible to do this in Excel?
 
B

Bernard Liengme

Use one data range for the "2x years" and another for the "4 weekly periods)
Fill empty cells with =NA()
best wishes
 

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

Gantt chart duration not showing 0
simple chart 0
sideways stacked bar charts with line series on the same axis 0
One extra x axis item that wont go away - can anyone help? 3
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Help with Bar-Line Chart..not aligned?? 1
Adding a line to a population bar chart 0
Adding a line to a bar chart 1

Top