Coding a chart from scratch

  • Thread starter Thread starter wj8801
  • Start date Start date
W

wj8801

I'm looking to code a chart in vba using data from my tables or
queries and displaying them in a form using rectangle shapes. How
would i go about doing this?
 
Hi

You can code Charts using the MS Chart Object model. This enables you to
produce any of the charts normally available if you 'manually' insert them,
together with all the display/formatting options etc.

Its fairly straightforward but there is loads of it - far too much to lay
out here!

You can get an idea of what's involved by launching a new a macro in Excel,
produce a chart then examine the macro's coding.

I suggest that the best option is that you get yourself a book - search
Amazon for a VBA programming book and make sure it has a section on coding
charts.

Good luck.

BW
 
Hi

You can code Charts using the MS Chart Object model. This enables you to
produce any of the charts normally available if you 'manually' insert them,
together with all the display/formatting options etc.

Its fairly straightforward but there is loads of it - far too much to lay
out here!

You can get an idea of what's involved by launching a new a macro in Excel,
produce a chart then examine the macro's coding.

I suggest that the best option is that you get yourself a book - search
Amazon for a VBA programming book and make sure it has a section on coding
charts.

Good luck.

BW
Click to expand...

I have solved the problem now Thanks
 
Back
Top