PDA

View Full Version : Inserting a Range on a Chart as TextBox ?



Saladsamurai
10-02-2009, 11:42 AM
Alrighty then... Here is what I am trying to do:

I have a chart that is updates as data is entered onto a bunch of sheets.

I also have this Range that updates as well.

http://i12.photobucket.com/albums/a220/saladsamurai/ExcelChart.jpg

I would like to be able to put the Range on the chart as well, but it needs to be able to update, so I can't place it as a Bitmap or something.

I tried using a TextBox linked to the Range via the formula bar, but no dice.

Any thoughts?

Thanks

georgiboy
10-03-2009, 02:43 AM
If you have a chart sheet then this will not be easy, have you thought about having the chart in a normal worksheet and having your required range under/beside your chart. You could then set the print range and so on to suit the new layout.

Hope this helps.

Saladsamurai
10-05-2009, 06:59 AM
If you have a chart sheet then this will not be easy, have you thought about having the chart in a normal worksheet and having your required range under/beside your chart. You could then set the print range and so on to suit the new layout.

Hope this helps.

Yes, it is in a Worksheet, not a chartsheet. I am not sure what you mean by 'setting the print range' though. I am still new to all of this.

I will do some googling and see if I can figure out what you are implying.

Thank you! :)

Bob Phillips
10-05-2009, 07:42 AM
Change the axis source data to encompass the actual data.