Forum Discussion
How to create a "combination chart" ?
My data looks like this: Temperature Binned 66.6 MEIDUM 70.3 MEIDUM 69.2 MEIDUM 68.1 MEIDUM 67.2 MEIDUM 72.6 MEIDUM 73.2 MEIDUM 70.3 MEIDUM 57.6 LOW 63.1 ...
Hello JP_Zhang , I'm having trouble visualising the chart you want to create. Can you mock it up with the drawing tools and post a picture? To post a picture, click on the camera icon in the toolbar.
If you want to plot the count and the average, you first need to calculate these numbers somewhere in the workbook. In the screenshot, I have manually entered the words in column E and then used Countif and AverageIF formula.
Count =COUNTIF(B2:B24,E2) in F2 copied down,
Average =AVERAGEIF($B$2:$B$24,E2,$A$2:$A$24) in G2 copied down.
Then I added a clustered column chart and changed the Average series to a line chart.
Does this help?