Problem with OFFSET and Dynamic Chart
Hello, as you can see in doc attached, I have a Chart with vertical axis populed dynamically with OFFSET function.
My problem is the Horizontal Axis, where I need (you can see in the SERIES in the doc) two value (two column date and hour).
If I put in the SERIES the value "$A$2:$B$29" as you can see, two values are drawed in horizontal axis.
I need to use OFFSET also in this axis, so I can add new values and dynamically update the graph.
I don't know How to use OFFSET for two column, is it possible?
P.S. I have attached also excel file :-)
Thanks in advance
Best regards
Federico
| Attachment | Size |
|---|---|
| OffsetProblem.doc | 172 KB |
| fede_2012.xls | 664 KB |
You just need to set the
You just need to set the offset for your X series correctly.
I did this by changing your refers to of the HOUR range to
=OFFSET('Traffico per tipologia'!$A$1,1,0,COUNTA('Traffico per tipologia'!$B:$B),2)
Uses A1 offset 1 row down, 0 columns across, height = to data count, width 2 columns.
Add some data and the chart grows - as does the x range.