mcalabrese
New Member
I am new to Chandoo.org and I want to say that this site has already helped me immensely.. thank you! I am using Excel 2010, I have been using Pivot Tables for a few years, am faily new to Pivot Charts, and am extremely new to Slicers. Here is what I have so far:
2 tables of data (in same workbook, on separate worksheets):
Marketing Database
Includes:
Fiscal Year
Fiscal Period
Store
Expense Type (i.e. Advertising, Promotional, Donations, etc)
Expense Amount
Sales Database
Includes:
Fiscal Year
Fiscal Period
Store
Total Sales
I have already created 3 pivot charts (using the marketing database) to display Total Marketing Expenses by Expense Type (Horizontal Bar) , Total Marketing Expenses by Store (Pie Chart), and Total Marketing Expenses by Fiscal Period (Vertical Bar). I have these 3 charts on a dashboard along with slicers for Fiscal Period, Store, and Expense Type. The slicers are linked to all 3 pivot tables so they manipulate all 3 charts simultaneously.
I am trying to add sales data to the vertical bar chart (Total Marketing Expenses by Fiscal Period). What I would like to do is add a line graph that displays the Sales % increase over prior year by Fiscal Period (and have this data connected to the existing slicers - except for the Expense Type slicer). The 2 sets of data do have the Fiscal Year, Fiscal Period, and Store fields in common. I am hoping there is a way using these fields to connect this data in some manner.
I hope this all makes sense! Thank you advance for your time and support!
Matt
2 tables of data (in same workbook, on separate worksheets):
Marketing Database
Includes:
Fiscal Year
Fiscal Period
Store
Expense Type (i.e. Advertising, Promotional, Donations, etc)
Expense Amount
Sales Database
Includes:
Fiscal Year
Fiscal Period
Store
Total Sales
I have already created 3 pivot charts (using the marketing database) to display Total Marketing Expenses by Expense Type (Horizontal Bar) , Total Marketing Expenses by Store (Pie Chart), and Total Marketing Expenses by Fiscal Period (Vertical Bar). I have these 3 charts on a dashboard along with slicers for Fiscal Period, Store, and Expense Type. The slicers are linked to all 3 pivot tables so they manipulate all 3 charts simultaneously.
I am trying to add sales data to the vertical bar chart (Total Marketing Expenses by Fiscal Period). What I would like to do is add a line graph that displays the Sales % increase over prior year by Fiscal Period (and have this data connected to the existing slicers - except for the Expense Type slicer). The 2 sets of data do have the Fiscal Year, Fiscal Period, and Store fields in common. I am hoping there is a way using these fields to connect this data in some manner.
I hope this all makes sense! Thank you advance for your time and support!
Matt
