Hi all,
I have read that there is no way within VBA to determine a datasource of a chart. In lieu of that I would like to at least see the range that the chart is using by looking at the chart design in Excel (not VBA).
But what I see instead is a Blank where the Range should be, and a message to the effect "...the range is to complicated to display".
So my quandry is that I've been given some workbooks with charts that need fixing. However, I can't see what's wrong with the charts if I can't see where the data comes from. The quandry is that the charts "mostly work", and are reasonably accurate, but need tweaking. If I so much as touch the Range in the Series properties, I'm afraid I'll wipe out everything--and I rather have a "mostly working" sheet than one that's completely dead.
I have been given no direction as to what the chart should be--that would've been nice. My job was to 'analyze what's there' and fix it. But, like I said, I can't really analyze what's there because, while I can look at the chart results, I can't look at what the source was.
Is this info gone forever (except maybe in the original workbook creator's mind...who's not with the company any more)?
Thanks,
Jombi
I have read that there is no way within VBA to determine a datasource of a chart. In lieu of that I would like to at least see the range that the chart is using by looking at the chart design in Excel (not VBA).
But what I see instead is a Blank where the Range should be, and a message to the effect "...the range is to complicated to display".
So my quandry is that I've been given some workbooks with charts that need fixing. However, I can't see what's wrong with the charts if I can't see where the data comes from. The quandry is that the charts "mostly work", and are reasonably accurate, but need tweaking. If I so much as touch the Range in the Series properties, I'm afraid I'll wipe out everything--and I rather have a "mostly working" sheet than one that's completely dead.
I have been given no direction as to what the chart should be--that would've been nice. My job was to 'analyze what's there' and fix it. But, like I said, I can't really analyze what's there because, while I can look at the chart results, I can't look at what the source was.
Is this info gone forever (except maybe in the original workbook creator's mind...who's not with the company any more)?
Thanks,
Jombi