Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking to create a 2D line-chart in Excel 2007. It will have 2 Y-axes. The X axis will be dates. There will be 5 series. I want 3 of the series to be stacked and use one Y-axis, and the remaining 2 to stay unstacked and use the other Y-axis.

Is this possible?

share|improve this question
up vote 2 down vote accepted

Yes. Get all 5 data sets onto a chart first, then there are two steps:

  1. Right click on each of the ones you want on the y-axis. Select Format Data Series, and in the Series Options section change the Y axis to the secondary axis.
  2. Right click on each of the ones you want to change the chart type of and select Change Series Chart Type. Then you can have a different type for each series.
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .