Ben Conner
asked on
Programmatically generating charts in Excel 2010 VBA
Hi,
I'm struggling to come up with the code to programmatically add a series of charts to a test spreadsheet in Excel 2010 VBA. Haven't used VBA a whole lot and less with charts.
I've looked through a number of examples online and haven't found a combination that seems to work. Can someone peek at this and suggest a good example to use or sample code?
The first tab is called Distributions. A sample chart is to the right of the table, and the VBA code I've already created is in the workbook.
Much appreciated!
--Ben
salesexample.xlsm
I'm struggling to come up with the code to programmatically add a series of charts to a test spreadsheet in Excel 2010 VBA. Haven't used VBA a whole lot and less with charts.
I've looked through a number of examples online and haven't found a combination that seems to work. Can someone peek at this and suggest a good example to use or sample code?
The first tab is called Distributions. A sample chart is to the right of the table, and the VBA code I've already created is in the workbook.
Much appreciated!
--Ben
salesexample.xlsm
Do you want to create similar charts for each of the tables?
ASKER
Yes; the only thing that would change is the height of the bars. The code currently generates empty charts going down the right side.
--Ben
--Ben
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good grief! I've been messing with this for a day and a half. :) Wow. That's impressive.
Were I to want to add a title to each chart reflecting the table title (Wa Sales, etc.), how would that be added?
There's a LOT here for me to look up and see how you did that. I can't thank you enough for the help!
--Ben
Were I to want to add a title to each chart reflecting the table title (Wa Sales, etc.), how would that be added?
There's a LOT here for me to look up and see how you did that. I can't thank you enough for the help!
--Ben
Ben
This will add the chart title, put it after the code that sets the ChartType
This will add the chart title, put it after the code that sets the ChartType
cht.SetElement msoElementChartTitleAboveChart
cht.ChartTitle.Text = ws.Cells(rng.Cells(1, 1).Row - 2, "A").Value
ASKER
Thanks much!
Where would one go to read up on the techniques you used in this? I've read the Excel 2013 Power Programming with VBA by John Walkenbach but I don't recall seeing coding this sophisticated in it.
--Ben
Where would one go to read up on the techniques you used in this? I've read the Excel 2013 Power Programming with VBA by John Walkenbach but I don't recall seeing coding this sophisticated in it.
--Ben