0

I'm trying to do a histogram chart in excel. I have this values:

table with values

But I get something like this:

histogram chart

But it doesn't seem right, because I'd like something like this:

histogram chart

How can I get something like that?

  • The chart in your screen cap doesn't seem to correspond to the table. Can you provide a chart and data that match? – cybernetic.nomad Apr 4 '19 at 16:31
  • 1
    You're going to confuse people with a column chart (it's not a histogram, by the way) that shows different quantities on different axes. It is very hard to help people recall that two bars are currencies on one axis and one of the bars is a percentage on the other axis. I suggest that when you move your percentage to the secondary axis, you also change its chart type to a line with markers. It will still confuse people, but not so badly. – Jon Peltier Apr 5 '19 at 3:50
1

Here is one way of getting what you want.

  1. Add three columns to your chart, format two as percentages and the other as currency:

enter image description here

  1. Insert a chart (doesn't really matter what kind for now)

  2. Right-click on it and choose "Select Data..." from the pop-up menu

  3. Click on "Switch Row/Column so that the column headers (demand, export, etc...) are on the left hand side

  4. Move the "filler" series up until they are just below the "demand" series

enter image description here

  1. Click "OK", then right-click on the chart and select "Change Chart Type..." from the pop-up menu

  2. Select Combo chart as the chart type

  3. Select "Clustered Columns for all Series, and check "Secondary Axis for the first three.

enter image description here

  1. Click "OK"

  2. In the legend, select and delete the legend entries for the filler series

enter image description here

And you're done

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.