Creating Graphs In Excel With Multiple Data. The combination charts in Excel are also called as combo charts in the newer version of excel. May 06 2012 In order to do so.
Select bar and press Ctrl 1 which will open up the Format Data Series option to the right of the chart. In this Format Data Series option makes Gap Width to 0. Right click a column in the chart and select Format Data Series in the context menu.
To do it go back to the table in Excel you used to create the line chart and highlight the data points that make up the Y-axis in this case the dollar amount.
As we can see in the above image as soon as we make the Gap Width to. Select the chart choose Select Data from the ribbon or right click the chart and choose Select Data and click the Hidden and Empty Cells button at the bottom left of the Select Data Source dialog. Another Way to Create a Line Graph. Then copy it and paste it to the row below so there are two identical data series.
