Fun Excel Combo Chart Change Bar To Line

One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value.

Excel combo chart change bar to line. Adding a line to an existing graph requires a few more steps therefore in many situations it would be much faster to create a new combo chart from scratch as explained above. Next select Change Series Chart Type. In the chart shown in this example daily sales are plotted in columns and a line shows target sales of 500 per day.

Change horizontal axis values. Then right click to bring up the shortcut menu to to see Chart Type and select Line. After the chart is made just click on the one section of a column you want changed so all the sections are highlighted say TotalSales.

To begin right-click on the data series you want to change ad budget in this example. In the Change Chart Type window select Line on the left navigation bar then. Combo charts combine more than one Excel chart type in the same chart.

Select the Edit button and in the Axis label range select the range in the Store column. A combo chart will be created. The percentage columns are very short and we need to change them to a line chart.

To make Average temperature show up as a line change we need to select the chart Right Mouse Click and select Change Chart Type. I am currently using Excel PPt 2000 and cannot figure out how to control which rows of data are displayed as a bar or line in a combunation chart. However when I want to change the bar data series to a xy scatter plot the primary axis changes to a default 12345678 which I then cannot change.

I am trying to create a combo chart in excel with some data sharing the same primary axis. To change x axis values to Store we should follow several steps. Select and right click the newly created line and select Format Data Series in the context menu.