Forum Discussion
Bar Chart Overlay
I want to overlay a graph chart on top of my line chart that shows the color column data as hours in a day. Basically, I want one chart that will show how long I fasted and how much I weighed each day. Is this possible?
Yes.
Select the chart.
On the Chart Design tab of the ribbon, click Select Data.
Under Legend Entries (Series), click Add.
Enter Fasting or another descriptive text in the Series name box.
Clear the Series values box, then point to the colored column.
Click OK, then click OK again.
Click on the new series, or activate the Format tab of the ribbon, and select the Fasting series from the drop down in the Current Selection group.
Click Format Selection.
Specify that the Fasting series is displayed on the secondary axis.
Thank you! I seem to have gotten the line and bar working together properly now. I've run into another issue, however, with the secondary axis values. The numbers on the right seem to be arbitrary, though the bars themselves show the correct value. I can't figure out how to get it to show as 0-24 (or 8-24 is what I would prefer). Any ideas?
Double-click the secondary value axis.
Under Axis Options, enter the following
In Minimum: 0.3333333333333 (this corresponds to 8:00)
In Maximum: 1 (this corresponds to 24:00)
In Major: 0.08333333333333 (this corresponds to 2:00)
Expand Number near the bottom.
In the Format Code box, enter [h]:mm, then click Add.
Example with some dummy data:
