shared x-axis for column and scatter chart in same plot

[sophiereid]

chart.JPG

Have 3 sets of points in columns. Need to create a chart with column A in X-axis and columns B & C in primary and secondary Y axes. Column B represents the Column type chart and Column C represents XY scatter plot. When I plot these points in a single chart, I need the x-axis to be the same, representing the one for scatter plot. Currently, I get 2 x-axes: one for column and one for scatter. Can someone explain how to share x-axis for 2 charts?
A B C
Load Hours Energy
0 0 0
3 1 3
32 2 61
34 3 67
114 4 387
164 5 637
199 5 847


Thanks!

[cbatrody]

Hi,

Welcome to the Forum.

I have created a chart by going through the description provided by you. Please see if this suits your requirement (file attached).

[sophiereid]

Thank you so much. This helps a lot to move forward with my issue.