Forum Discussion
CharlesGonzalesAptos
Aug 22, 2020Copper Contributor
Help! Excel 2019 Home Edition with Analysis Toolpak not creating histograms/Pareto charts. Thanks!
Hi, I am having a heck of a time with Excel 2019 Home Edition - Installed on my new Dell. Here's the background information: 1. The histogram above is correct a. There are six data p...
mtarler
Aug 22, 2020Silver Contributor
CharlesGonzalesAptos I feel bad for you and don't have the answer. I would suggest attaching your sheet and hopefully that will help someone to help you.
That all said I can make an observation that I can only hope might help. Both of the 'wrong' histograms are plotting a histogram of the second set of data. Basically not using the values of your histogram as the values but actually performing a histogram of those numbers. I'm not sure how it is picking the ranges but they are even sizes/ranges.
Also, since you already have the histogram table why not just use a bar chart to plot those values?