Hi,
I have the following data organized by account type in column A and account balances in dollar values per month in columns B-Z. I want to use a pivot table/pivot chart to show what has happened to the accounts via line graph over time. My column headers are January through December with the $ values below. When I create a pivot chart, it creates a table with account types listed on the x-axis and $ value on the y-axis. What I want is the headers January--December on the x-axis, dollar values on the y-axis, and the account types to be graphed as lines.
I can achieve this by doing a chart by switching the row/column feature on a regular chart, but I would prefer a pivot chart because I want to look at the data from multiple angles. I've tried a variety of things, any help would be greatly appreciated.
I consider myself an expert in excel and can say I'm thoroughly stumped by what is probably a simple task.
Bookmarks