How to create a histogram and a line chart combo

Copper Contributor

Is there a way in office 365 to make a histogram and a line chart combo?

1 Reply

@My_username_134 

You can create a combination of a histogram and a line chart in Excel 365 by using a combination chart. Here are the steps to create a histogram and line chart combo:

  1. Prepare Your Data:
    • Organize your data in a worksheet. Typically, for a histogram, you will have a column of numerical data. For the line chart, you might have another column of data that corresponds to the points on the line.
  2. Create the Histogram:
    • Select the column containing your numerical data.
    • Go to the "Insert" tab in the ribbon.
    • In the Charts group, click on the "Histogram" button. If you do not see it, you might find it under "Statistical Chart" or similar, depending on your Excel version.
    • Excel will generate a histogram based on your data.
  3. Create the Line Chart:
    • Select the column of data that corresponds to the line chart.
    • Go to the "Insert" tab again.
    • In the Charts group, choose the "Line" chart type.
  4. Combine the Charts:
    • Click on the line chart to select it.
    • Right-click on the chart, and choose "Format Data Series" or "Format Data Point," depending on your Excel version.
    • In the Format Data Series pane or dialog box, choose the option to "Plot Series On" the secondary axis.
  5. Adjust Axis Scaling (if needed):
    • If the scales of the two charts are significantly different, you might need to adjust the axis scaling.
    • Click on the axis you want to adjust.
    • Right-click and choose "Format Axis."
    • Adjust the minimum and maximum values as needed.
  6. Format the Charts:
    • Customize the appearance of your charts by adding titles, labels, legends, and other formatting options.
  7. Finalize the Combo Chart:
    • You now have a combination of a histogram and a line chart. You can further customize the chart as needed.

Remember, the specific steps might vary slightly depending on the version of Excel you are using. The key is to use the "Format Data Series" options to plot the line chart on the secondary axis. Experiment with the settings until you achieve the desired combination. The text and steps were edited with the help of AI. If you encounter any issues or need additional guidance, provide more details about your data. In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.