Hi pcg,
Thnaks for the reply.
I am trying (i think), what you suggested but its not working. I think this is cause I have either mis-understood your instruction, or I'm trying to do too much with it.
I have named a cell YValues. In that cell I have the formula: =IF(K35="Branch Related",T9:T13,IF(K35="Complaint",T14:T23,IF(K35="Delivery",T24:T39,IF(K35="Guest Related",T40:T44,IF(K35="Post - Event",T45:T53,IF(K35="Pre - Event",T54:T66,IF(K35="Registration",T67:T72,0)))))))
Basically what you suggested, but with 7 different data ranges, not 2.
I also tried naming another cell XValues, and using the formula: =IF(K35="Branch Related",R9:R13,IF(K35="Complaint",R14:R23,IF(K35="Delivery",R24:R39,IF(K35="Guest Related",R40:R44,IF(K35="Post - Event",R45:R53,IF(K35="Pre - Event",R54:R66,IF(K35="Registration",R67:R72,0)))))))
Which would change the x axis depending on cell selection (or would it).
Either way, when I use only YValues as series data or the Y and X values for Series and Category, it just wont work.
Apologies for taking up more of your time, but if you can set me striaght, it would be appreciated.
Kind regards