Attached is a file with 3 sheets.
12-31-2014 - Dated raw data sheet from which summary charts are being derived on other sheets.
SummaryOLD- this sheet is a manual summary of the key data from the sheet above. CLICK in any cell in column A and chart I've designed pops up showing a column chart with the total values for each year for the row you clicked. You can shift-click multiple cells in column A and get multiple charts side by side.
This works as desired.
Summary - this is the new sheet I'm trying to enhance and I've hit a wall. This sheet has the same summarized data in the first few columns, but over in the columns AA and over I've collected and sorted the individual rows that make up that summary data.
Click on any cell in column A and you will see a multi-column bar chart. If the person you click has more than one event in the sorted data over in AA, you will get multiple columns.
Problem:
The FUNCTION of this sheet is exactly what I want. But the CHART is not. I do not want to create side-by-side column bars, I want to create a StackedColumn chart, showing a single bar for each year with the portions stacked together.
I've Googled and searched and can find no way to create the same exact layout chart I have on my SummaryOLD (single bar for each year, title at the top with the manager and the employee name) on my new Summary but as a standard StackedColumn chart to show all events in a single bar.
A bonus would be to get the $ amounts to list on the bar:
http://screencast.com/t/4jGQlIJhV8
All the code is in the sheet modules.
Bookmarks