I am trying to make a combo chart (bar and line). Usually, a simple way is to add a dual y-axis. However, sometimes this could be confusing. Recently, I came across some alternative options, and I was wondering if this would be possible to do this in excel. Please see the attached example. Thanks
Dual y-axis in chart
chartsmicrosoft excel
Related Solutions
If you use the series (0,1,2,4,8,16) as Horizontal Category (Axis) Labels, Excel will always equally spread the values unless you select one of the Scatter chart types.
After selecting a Scatter chart for your data, you will see that your x-axis labels will spread according to their values.
I don't understand quite. What kind of graph do you want ? This ?
To get this, choose your chart as a linear type (xy scatter group). After that go to select data, and select x and y values by hand from series 1. After that, fix up a little your x axis properties, so the year shows every year, and not every two or so ... Might want to fix up the default look of the graph too.
Best Answer
These can both be (rather) easily accomplished in Excel.
The first example is a basic combo chart (clustered column and line with markers), then formatted to taste.
The second example is two charts (as noted by Emily). Use Page Layout>Align>Snap to Grid to align the Chart and Plot Areas so the Axis are nicely aligned. Change the Border to No Line for a seamless experience (I only have it turned on to show the relative borders).