R
robert2b
i am trying to create code that goes down a list of named excel ranges and
creates a complete ppt chart (title with graph and annotated text), one for
each excel range. the chart will be customized based on the contents of the
named excel range.
there may be easier ways, but i thought that if i could reference and change
the ppt chart data directly from the excel file procedure, i can set it equal
to the excel file data range name that i want. i have been trying to use
sourcedata and chartdata but i keep getting compiler errors. any help is
welcome, even if it is a reference book that i can buy.
thank you!
creates a complete ppt chart (title with graph and annotated text), one for
each excel range. the chart will be customized based on the contents of the
named excel range.
there may be easier ways, but i thought that if i could reference and change
the ppt chart data directly from the excel file procedure, i can set it equal
to the excel file data range name that i want. i have been trying to use
sourcedata and chartdata but i keep getting compiler errors. any help is
welcome, even if it is a reference book that i can buy.
thank you!