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 have a combination chart with a bar chart and 2 line graphs on secondary axis. have to exactly match the formatting in the screenshot attached ( I do not have the actual excel file. just have a screenshot). If you have a look - you can see the markers on line graphs do not align. The red line markers are skewed slightly to the left. Also, in the legend at the bottom - secondary axis legends are separated out to the bottom. I don't know how to do that either. Any help is greatly appreciatedenter image description here

share|improve this question

migrated from stackoverflow.com Feb 23 '11 at 2:30

This question came from our site for professional and enthusiast programmers.

up vote 0 down vote accepted

Here's a sample mock-up of a chart done entirely in Excel: no vba, just standard charts

Example Chart

It's actually two charts placed one over the other.

  • Bar chart is standard clustered column chart
  • Line chart is xy chart, and is placed on top of the column chart
    • Plot area and chart area set to no fill
    • X range is a consecutive series with enough resolution to place the markers where you want them
    • Y values are only entered for the points you want to plot, other cells are empty
    • Data source, hidden and empty cells set to 'Connect data points with line'
share|improve this answer
    
Thanks a lot Chris ! Worked perfectly !! – user68753 Mar 7 '11 at 6:22

i don't think you can make Excel do such things by itself. If someone is demand a pixel-perfect copy, they're going to have to take multiple source Excel graphs, and composite them manually in Photoshop.

You could have different x-values for the red and the black line graphs, that can let you position the points at whatever improper position you require.

But i don't think you have have both on one graph at the same time.

share|improve this answer
    
Thanks a lot Ian. Just wanted to make sure this un do-able in Excel – user68753 Feb 23 '11 at 4:33

This tutorial shows how to get the markers to line up with the columns:

http://peltiertech.com/Excel/Charts/ClusterColAndLine.html

Excel won't give you split legends like that. I'll bet someone took a screen shot of a legend and pasted it into the chart.

share|improve this answer

You must log in to answer this question.

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