Actually the case that I can't chart two dimensions w/out naming columns with one of the dimensions?
I have a really common data set. Three columns:
PERSON, MONTH, MEASURE
The MEASURE can be anything. Dollars, widgets, hairs pulled from head after trying to solve this.
Is it actually the case that I cannot:
Put Person on the X, Measure on the Y, and colored-coded bars for the relevant month
Put Month on the X, Measure on the Y, and color-coded bars for the relevant person
I need to create a column for each person or for each month? Which means I need to edit this thing every month? And by edit I need to edit the source data, and then go into the chart on the dashboard and edit the range of the data?
Is there no way to make this happen dynamically? I know that one way is, instead of putting my month names in the column, put numbers (1 for last month, 2 for the previous, etc), and then in a formula use LARGE and COLLECT to place the correct data. But that makes an annoyingly cryptic chart.