histogram and a line graph on the same graph?
 

how can i combine two graphs together?
can i superimpose one on top of another?

Answer: histogram and a line graph on the same graph?
 

Yes, you can combine a histogram and a line graph on the same graph in Excel. There are a few different ways to do this, but one common method is to use a secondary axis.

Here are the steps to combine a histogram and a line graph using a secondary axis:

1. Create your histogram and line graph separately. Make sure they are both on the same worksheet.
2. Select the data range for your histogram, including the column headers.
3. Click on the "Insert" tab in the Excel ribbon.
4. Click on the "Recommended Charts" button.
5. Select the "Histogram" chart type from the list of recommended charts.
6. Your histogram should now be displayed on the worksheet.
7. Select the data range for your line graph, including the column headers.
8. Click on the "Insert" tab in the Excel ribbon.
9. Click on the "Line" chart type from the list of chart types.
10. Your line graph should now be displayed on the worksheet.
11. Click on the line graph to select it.
12. Right-click on the line graph and select "Change Series Chart Type" from the context menu.
13. In the "Change Chart Type" dialog box, select the "Combo" chart type.
14. In the "Combo" chart type, select the "Line" chart type for the line graph.
15. Click on the "Secondary Axis" checkbox for the line graph.
16. Click "OK" to close the "Change Chart Type" dialog box.
17. Your histogram and line graph should now be combined on the same graph, with the line graph displayed on a secondary axis.

You can adjust the formatting and appearance of the chart as needed to make it look the way you want. For example, you can change the colors, add titles and labels, and adjust the axis scales.

Hi,
Say you have 2 series you want to display on a graph with differetn graph
type.
- Add the 2 series as for a regular graph. Say you use Bar chart for now.
- right-click (select) one of the series once displayed, and choose 'Chart
Type' from the pop-up menu. Choose Line chart from the dialog.
-- now you should have both series displayed with different type (Bar &
Line)

Now, say the 2 series have different scale, so you want them to be displayed
on 2 different Y axis:
- right click the series you want to display on a second axis.
- choose Format Data Series from the pop-up menu and in the Axis tab choose:
Plot Series on Secondary Axis.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"need help quick" wrote:

how can i combine two graphs together?
can i superimpose one on top of another?