rkspeaks
Member
Hi Excel Ninjas,
I have a chart data which runs from left to right as dynamic categories. I have a drop down to select these items in A2. Categories as Horizontal... Fruits, Clothing, Auto, Gadgets etc and can increase in future. Criteria as Vertical...Sales, Profit, Advance which are 3 rows and fixed for all categories. If I select any category say Fruits or Clothing or Auto in A2, I want a chart for the vertical rows i.e. Sales, Profit and Advance. I used the below named range but failed to link it to the chart axis. I attached my sample sheet below. Please help me.
=OFFSET(Sheet1!XFA3,0,MATCH(Sheet1!C4,Sheet1!$B$1:$E$1,0),3,1)
Thank you
RK
I have a chart data which runs from left to right as dynamic categories. I have a drop down to select these items in A2. Categories as Horizontal... Fruits, Clothing, Auto, Gadgets etc and can increase in future. Criteria as Vertical...Sales, Profit, Advance which are 3 rows and fixed for all categories. If I select any category say Fruits or Clothing or Auto in A2, I want a chart for the vertical rows i.e. Sales, Profit and Advance. I used the below named range but failed to link it to the chart axis. I attached my sample sheet below. Please help me.
=OFFSET(Sheet1!XFA3,0,MATCH(Sheet1!C4,Sheet1!$B$1:$E$1,0),3,1)
Thank you
RK