RobbieC
Active Member
- Joined
- Dec 14, 2016
- Messages
- 376
- Office Version
- 2010
- Platform
- Windows
Hi there, I have a column (A) with 40 potential inputs (time) and column B, readings of water depth at each time.
Is it possible to produce a dynamic graph based on these data sets in Excel 2010? Unfortunately, I'm stuck with the version.
What I'm aiming to do is have the y-axis scale to the time and the x-axis scale to width for the number of inputs (ie, the used range to the full width of the graph)
I think this is possible in later versions by using =offset(range), but if anyone has any good tips as to how I can produce these (or similar) in 2010, I'd be very grateful
Thanks
Is it possible to produce a dynamic graph based on these data sets in Excel 2010? Unfortunately, I'm stuck with the version.
What I'm aiming to do is have the y-axis scale to the time and the x-axis scale to width for the number of inputs (ie, the used range to the full width of the graph)
I think this is possible in later versions by using =offset(range), but if anyone has any good tips as to how I can produce these (or similar) in 2010, I'd be very grateful
Thanks