Good morning all.
Excel Version = 2003 XP
Is it possible to use formulae within Chart Data Ranges?
What I need to do : (simplified)
Columns A & B = The data I want charting
Column C = An indicator 1, 2, 3 or 4
I have 4 charts
Each chart charting the data for the relevant indicator.
At present I have to sort the data by column C, and change the data ranges to take into account the ever increasing number of rows due to additional data.
Is it possible to say =IF($C:$C=1, then chart the data in columns A and B)
Similarly for 2, 3, and 4 and so on.
I hope this makes sense!
Mark.
Excel Version = 2003 XP
Is it possible to use formulae within Chart Data Ranges?
What I need to do : (simplified)
Columns A & B = The data I want charting
Column C = An indicator 1, 2, 3 or 4
I have 4 charts
Each chart charting the data for the relevant indicator.
At present I have to sort the data by column C, and change the data ranges to take into account the ever increasing number of rows due to additional data.
Is it possible to say =IF($C:$C=1, then chart the data in columns A and B)
Similarly for 2, 3, and 4 and so on.
I hope this makes sense!
Mark.