Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

add comment

3 Answers

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
add comment

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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.