Excel historgram question

[joejackson123]

Hi All, I'm making an Excel histogram with 100 bins. I don't want 100 labels for the bin values, however. How can I limit the number of labels on the bins (i.e. have 100 bins but only 5 value labels)?

Thank you!

 

[thisoldman]

If you use Excel's histogram chart type, or the Analysis tool pack's histogram, there aren't many (any?) options I've found for creating a custom axis. If you use a column chart, there are several different ways create a custom horizontal axis.

Without knowing more details, all I can suggest is a Google or Bing search of Peltier Tech Blog. For either search engine, type these exact search terms in:

excel histogram custom axis siteeltiertech.com

The "siteeltiertech.com" limits the search to peltiertech.com only.