Excel VBA - Applyinging newly imported data range to a chart
Hi
I import data into Excel from both SQL and Access and generate fairly complex charts in Excel manually.
In the past I have encountered a lot of problems using Excel VBA to automate this so I want to rather apply the imported data range to each chart.
I need a few pointers on the best way to do this so that the chart doesn't lose any of its original structure.
I import data into Excel from both SQL and Access and generate fairly complex charts in Excel manually.
In the past I have encountered a lot of problems using Excel VBA to automate this so I want to rather apply the imported data range to each chart.
I need a few pointers on the best way to do this so that the chart doesn't lose any of its original structure.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks very much
ASKER
Hi Rory. I asked a further question relating to your answer:
https://www.experts-exchange.com/questions/27986886/Excel-VBA-looping-and-altering-the-XValues-and-Values-properties-of-each-series-in-the-charts.html
https://www.experts-exchange.com/questions/27986886/Excel-VBA-looping-and-altering-the-XValues-and-Values-properties-of-each-series-in-the-charts.html
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
http://www.microsoft.com/en-us/bi/powerpivot.aspx