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
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