Is there an easy way to create charts for individual rows in a spreadsheet and/or table?
I'm trying to compile and graph sales data for multiple locations over the latest 10 year period. The problem is that I need to save and present each individual graph separately, so the typical pivot chart won't help.
I need to graph individual sales numbers, as well as regional averages and averages based on size classifications (A,B,C,or D). I also need to update these numbers on an annual basis and have the charts update as well.
I have all of the data in a table format with the locations in rows and the yearly sales data in columns. I'm not very proficient with macros or VBAs.
Any suggestions?
Bookmarks