I'm modifying a histogram graph to read from different cells. When I attempt to rebuild the chart with the same data and same formatting, it results in a different graph. Any idea why this is so?
column graph format.PNG
When I was working just two hours ago, I got the chart on the left. Now I get the chart on the right. I used the same values, then used copy formatting.
How do I get Excel to read the 1,2,3,4 as categories and not values? I want to apply the same formatting as my previous histograms.
Bookmarks