Cool Line Chart And Bar Chart Together In Excel

The chart appears as shown in the following image.

Line chart and bar chart together in excel. Since we probably want the categories listed in the same order as in the worksheet lets select the vertical axis which in a bar chart is the X axis and press Ctrl1 the shortcut that opens. To change Columns to Line chart. This example uses a combo chart based on a column chart to plot.

Total time 60 seconds. About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy Safety How YouTube works Test new features Press Copyright Contact us Creators. The percentage columns are very short and we need to change them to a line chart.

Select the entire table to be plotted on the chart. Insert a blank row after every zonal group. Line graph of series 1.

In this example we will plot Ideal values on a bar chart and see how the five leading brands measure up with a line XY series for each brand. The data of every zone are grouped together at one place. A combination chart is a chart that combines two or more chart types in a single chart.

Hello I am trying to create a line chart to show one point of data and a bar chart to show a different point of data. Interchange the month and zone columns. Click the Line option and select the type of line chart you want to use from the Line menu.

Select the first two columns of the data and insert a bar chart. Secondary axis X-axis shows months. But first we need to add a column to hold our dataor create another small table with our year-end stats.