The conversion uses this formula (fill in the appropriate cell addresses for your worksheet):Īrea Value = Area Scale Min + (Time - Time Min) / (Time Max - Time Min) * (Area Scale Max - Area Scale Min) Using 1000 for a chart that’s a few hundred pixels wide is a reasonable resolution, though you could use something larger, like 10,000. It contains the minimum and maximum X values (minimum and maximum times) from the XY chart, and the minimum and maximum values I will use in the area chart series. The calculated values in the middle column are based on the small table to the right. I inserted a column between the Time and Count columns, containing calculated X values for the area chart that will provide the fill color. I added a row at the top of the data for the left edge of the chart, and another row at the bottom for the right edge of the chart. I started with the data from Histograms Using Excel XY Charts. In this post I will show how to extend that technique to fill the bars, using the protocol from Fill Below an XY Chart Series with an XY-Area Combination Chart. The drawback of that technique is that it produces histogram bars in outline only, without a fill color. This technique produces a human-friendly numerical X axis scale, which is easier to read and harder to be deceived by than the bin labels used by column chart histograms. I recently showed how to create Histograms Using Excel XY Charts.
