adding comments to dynamic charts

SamS

Well-known Member
Joined
Feb 17, 2002
Messages
542
I have a spreadsheet which uses array formulas to creat dynamic charts ie I have a drop down list box from which to select a title and the correct graph is displayed. The problem is I would like to add comments preferably next to the data and have it displayed on the graph, is this possible. I have no idea where even to start on this.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
check out the functionality offered by the "XY Chart labler:

http://www.appspro.com/

it might have what you need. If not, post back with more details about exactly what you're trying to do.

paddy
 

SamS

Well-known Member
Joined
Feb 17, 2002
Messages
542
Thanks Paddy, I once before tried the Chart Labler but unfortunatley the organisation I work for has admin rights (NT4) locked on just about everything and they didn't approve the above to be loaded so I have to try work arounds all the time. What I have is a Staff Establishent Database and using an array formula eg =IF(INDEX(INDIRECT(VLOOKUP($C$5,DEPTS,3,FALSE)),2,0)=0,NA(),INDEX(INDIRECT(VLOOKUP($C$5,DEPTS,3,FALSE)),2,0)) I use a combo box (from the Forms toolbar) to select a specific department which then updates a graph. This way I only need the one graph and can select any of 30 depts to view.

My problem is that several restructuring processes have taken place some minor some major and I need to be able to make comments on the graphs at specific points or at least when the appropriate graph is displayed. As the graph is dynamic ie it only exists when a selection is made I have no idea on how to make this happen.

PS: The formula most probably could also be tidied up but it can wait.

PPS: I would like to use Colo's HTML file maker but the above reasons apply which causes me no manner of angst.
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Sam,

'simple' method would be something like the following:

add a text box to the chart. select the box, then in the formula bar make it's contents

=C1

then stick a formula in C1 that picked up the appropriate comments from another cell

paddy
 

SamS

Well-known Member
Joined
Feb 17, 2002
Messages
542
Paddy now that you have mentioned it, it is too simple :oops: As you said I will point a text box at a cell with it's own array formula in it to pick the respective comment. Either getting old or it's been a long year (I'm hoping it's the latter).

Many thanks for your help :)
 

Forum statistics

Threads
1,148,007
Messages
5,744,319
Members
423,861
Latest member
Ka3EeM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top