aamirsq Member Mar 2, 2015 #1 Hi, I am having little problem here anyone with suggestion ? i want to display in chart data only upto selected month. Attachments Chart example.xlsx Chart example.xlsx 18.6 KB · Views: 3
Hi, I am having little problem here anyone with suggestion ? i want to display in chart data only upto selected month.
N Nebu Excel Ninja Mar 2, 2015 #2 Hi; Please find the attached. Thanks Attachments Chart example.xlsx Chart example.xlsx 18.7 KB · Views: 5
N Nebu Excel Ninja Mar 2, 2015 #4 Hi: what do you mean by "How do you link it?"? I am using name ranges and offset formulas to make the chart dynamic. Thanks
Hi: what do you mean by "How do you link it?"? I am using name ranges and offset formulas to make the chart dynamic. Thanks
aamirsq Member Mar 2, 2015 #5 What i do is "from sheet 1, i select all [A2:M4] data and click recommended charts style 2." extremely simple. So what else did you do with it ?
What i do is "from sheet 1, i select all [A2:M4] data and click recommended charts style 2." extremely simple. So what else did you do with it ?
N Nebu Excel Ninja Mar 2, 2015 #6 Hi: I have made the your chart dynamic using offset function in name ranges. Your chart will now change dynamically as per the selection you make in the drop down. Find the attached. Thanks Attachments Chart example.xlsx Chart example.xlsx 18.2 KB · Views: 7
Hi: I have made the your chart dynamic using offset function in name ranges. Your chart will now change dynamically as per the selection you make in the drop down. Find the attached. Thanks
