How to create a chart based on a 2 dim data range dynamical in 1 d
How can I create a chart based on a 2 dimensional range of data, which is
dynamical in one direction? Problem: set of data in rows. A named (dynamic) label range: €śwk2005€ť=offset($E$2,0,0,1,counta($2:$2)-2). Named value range: €śData€ť=offset(wk2005,22,0,5,counta(wk2005)). Series 1 of chart should have the values of row 22. Series 2 should have the values of row 23 etc. through to series 5. The name of the 1st series is placed 3 columns to the left of the first data point (E24). The name of the 2nd series is placed 3 columns to the left of the second data point (E25) etc. The x-labels is simple: wk2005. I try to use the offset function in the €śsource data values box€ť of the chart but I cannot get it to work. Please advise. |
All times are GMT +1. The time now is 09:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com