Problem with histogram

Hi,

could you help me make a histogram with median, avg and mode on it. I fallow the instructions post here https://peltiertech.com/Excel/Charts...ertSeries.html but in my case the problem is X axis which is not a data axis. Is the only way to position on proper place median, avg and mode is to change the scale of secondary axis ?

Thanks for help !

short answer: imho, yes

So how can we make histogram with additional metrics like median? What chart to use ?

Like you said, "additional"
You just did it on the second chart.
MS gives you standard (automatic) capabilities and you have to tailor them to your needs.
If you want to automatically adjust the primary and secondary x axis relationship you will need VBA

here is example of VBA: https://www.excelforum.com/excel-gen...ml#post4692432

Ok it was possible without VBA. Thanks for help!