Hi,
I'm currently creating a PivotTable chart, with multiple columns of data. Here's an example of the data column names.
14.1, 14.2, 14.3, 15.5, 15.6, 17.1, 17.2, and so on.
What I'd really like to show is just 3 columns: 14, 15 and 17. However, within each column, I'd like to break out the value of the smaller pieces. So, if 14.1 had a value of 2, 14.2 had a value of 5, and 14.3 had a value of 4, column 14 should now have a value of 11 (2 + 5 + 4). However, I'd like to delineate each of those 3 values within that column. Can that be done?
Thanks,
Mike
PS I've attached a spreadsheet that should hopefully illustrate the problem.
Bookmarks