Hi Guys,
I am producing a dynamic chart which scrolls data using the OFFSET function.
I am looking to custom label this graph.
The data is stored in a column and i would like to add another column which holds all the label data. this way I can imput my own data or use formulae to add my own custom labels to the chart.
Is this possible?
It may make it more difficult with the scrolling chart.
Please see
http://www.ozgrid.com/Excel/scroll-data-chart.htm
to see the chart example.
I cannot upload it as the file exceeds limits.
Any help with this would be greatly appreciated.
Many Thanks
Using the example scrolling chart you linked to, one approach could be:The data is stored in a column and i would like to add another column which holds all the label data. this way I can input my own data or use formulae to add my own custom labels to the chart.
Place the custom labels in a column adjacent to the data series then adjust the column offset of the named range to reference the column.
Example: using column-A (empty in the example workbook) to hold the custom labels, you would change the dynamic named range formula
From:
=OFFSET(Sheet1!$B$1,Sheet1!$E$2,0,Sheet1!$E$3,1)
To:
=OFFSET(Sheet1!$B$1,Sheet1!$E$2,-1,Sheet1!$E$3,1)
So that as you scroll the label follow the series data points.
If you want a more precise or need a different solution upload a sample workbook illustrating what you want.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks