Spectacular Chart Type Display 2 Different Data Series
Click the All Charts tab and select the Combo category.
Chart type display 2 different data series. Visit us at httpwwwdeerswoodcoukThis netcast shows how to have two data series with different scales on one Excel chart. Fill in entries for series name and Y values and the chart shows two series. You must make sure that the series are aligned.
This combo chart will split the series 5050 between a clustered column and a line chart. To create a combo chart select the data you want displayed then click the dialog launcher in the corner of the Charts group on the Insert tab to open the Insert Chart dialog box. Right-click on the Expected value data series and choose the Line Chart.
The formatting bar should appear on the right hand side. I have a list of datestimes in column A in column B I have values of those datestimes. Now you can further determine on which axis.
Sometimes in a combination chart the values of one data set vary. Adding Secondary Axis to Excel Charts. Is it possible to easily display two different chart types for the same data series.
With repeating above steps you can combine more than two chat types you just need to select the additional data sets and choose a different chart for each data series. Add a secondary axis for the combination charts. You cannot separate different series into different chart.
Then click OK button and now you have a chart with two chart types as following screenshot shows. For more information see Aligning Data. The X and Y values of separate series in an XY chart may be completely independent.