Move markers of line chart/ Format legend

Question

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 appreciated

Solution

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

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'

Comments

[user68753]

Thanks a lot Ian. Just wanted to make sure this un do-able in Excel