Clustered Column Combo Chart. Click the Quick Analysis Tool button and then click the Charts tab. After that Go to.
To let me draw a 5 constant line. To do that we need to select the entire source Range including the Headings. For example on the Column tab select the Clustered Column chart.
For the red series copy the range B8C11.
Under Choose the chart type and axis for your data series check the Secondary Axis box for each data series you want to plot on the secondary axis and then change their chart type to Line. Then download our TEST4U de. Start by making a clustered column chart using the first three series of data. The tooltip would be a standard one in the bars but in the line.
