Just consider the following problem. I have an Excel table with SIX columns: L, X, Y, S, A, B. I want to generate a SINGLE bubble chart with several data series.
L column is used for LABELS
X column is used for X-AXIS
Y column is used for Y-AXIS
S column is used for SIZE of bubbles
So far, everything is ok. I know how to do it.
No, I want to generate a data series for EACH combination of values of columns A and B. For example, if A is {F,G} and be is {1,2}, I want four series, F1, F2, G1, and G2, each one featuring a different bubble color.
At the moment, the ONLY way I found to do that, is to sort the table by column A and B and manually set the data for each series. This is a very primitive approach, because if I delete or add records to table, I have to do it again. Furthermore, if I work on table by filtering or sorting records for other analysis, the chart is completely disrupted.
Any idea how I can do that without using code?
Bookmarks