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 weighe...
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: