I was making a chart in an Excel spreadsheet the other week and it insisted on adding trailing zeroes in the charts after the decimal point, even though all of my stats were whole numbers. Here’s the solution I finally found to get rid of trailing zeroes in Excel charts.
My boss’ management is clamoring for metrics. They want to know, at a glance, what we’re doing and how far along we are. Sounds like a job for stacked bar charts in Excel to me.
Figuring out a way to track our progress was fairly easy. Figuring out how to make Excel display that chart in a meaningful fashion… Well, that took about five hours. I’ll try to make it easier for you than it was for me.
Continue reading Stacked bar charts in Excel