I'm trying to do a histogram chart in excel. I have this values:
But I get something like this:
But it doesn't seem right, because I'd like something like this:
How can I get something like that?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
Here is one way of getting what you want.
Insert a chart (doesn't really matter what kind for now)
Right-click on it and choose "Select Data..." from the pop-up menu
Click on "Switch Row/Column so that the column headers (demand, export, etc...) are on the left hand side
Move the "filler" series up until they are just below the "demand" series
Click "OK", then right-click on the chart and select "Change Chart Type..." from the pop-up menu
Select Combo chart as the chart type
Select "Clustered Columns for all Series, and check "Secondary Axis for the first three.
In the legend, select and delete the legend entries for the filler series
And you're done