I have a few charts that need to be set to automatic axis value because the data is always changing, but I need to be able to have the charts "zoomed in" to be able to see the differences between the categories. I've attached a sample excel spreadsheet so you can see what I'm talking about.
Bookmarks