I have a requirement to have dynamic chart based on selection from particular fields. In attached app, I am able to change the chart type from line chart to straight table or vice versa(through macro).
Now, I would like to have an addition of some codes in existing macro which will defined chart type basis on my selection from account field.
For example: If i select Account 1 then it will show scatter chart, if I select Account 2 then it will show line chart and if I select Account 3 then straight table will be the view.
Below is the macro which i have used in attached app.
set chart = ActiveDocument.GetSheetObject("CH04")
intObjectType = chart.GetObjectType
if intObjectType = 15 then 'is currently a line chart
Kindly advise how to write in macro to achieve above output.
Step by step:
LOAD * INLINE [
I attach you another app.