Hi there,
Can someone tell me is it possible to group together rows (which are unrelated text) in a pivot table for a chart?
Say I have 5 rows of names and their value. I would ideally like to create a combo chart, to show row 1 vs row 2-5
Company> Project > resources
Genes >Project 1 > 12
Matts >Project 2 >3
Raddo >Project 3 >8
Bango >Project 4 >6
Harmo >Project 5 >14
If rows 2-5 could be in a stacked area or bar chart showing how each name contributes to the overall number - it would be awesome
Bookmarks