Charts or Graphs in Access

[Lester Lane]

Hi,
I'm doing my nut on this one! I can't tell from the help whether I'm
looking at an Excel help or Access now that I have added various
References that allow charts. Looking at other questions on this
topic has not made it any clearer.

My code of far!

Dim objChartSpace As ChartSpace
Dim objChart As ChChart

Set objChartSpace = Me.ChartSpace6 (object on the form)
Set objChart = objChartSpace.Charts.Add (wishful thinking!)

The object does not get set. I wish to "simply" add a chart to a form
that displays some subform data graphically and will requery on the
user selecting different records. Can someone please point me in the
right direction? Thanks.

 

[Crystal (strive4peace)]

Hi Lester,

why not create the chart on the form and set RecordSource
and make it visible when you want to change and show it?

You can also change the size of the chart when you show/hide
it if you don't want it taking space on the form when you
are designing

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
have an awesome day
*

 

[Lester Lane]

Hi Lester,

why not create the chart on the form and set RecordSource
and make it visible when you want to change and show it?

You can also change the size of the chart when you show/hide
it if you don't want it taking space on the form when you
are designing

Warm Regards,
Crystal
remote programming and traininghttp://MSAccessGurus.com

free video tutorialshttp://www.YouTube.com/user/LearnAccessByCrystal

Access Basicshttp://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

  *
    have an awesome day
  *

Thanks but the chart (Microsoft Office Chart 11.0) does not have the
RecordSource option, it is far more complex than that. What type of
graph should I add if I want your solution please? Thanks

 

[Lester Lane]

Thanks but the chart (Microsoft Office Chart 11.0) does not have the
RecordSource option, it is far more complex than that.  What type of
graph should I add if I want your solution please?  Thanks

Ahhh! Fixed it by clicking New form with New with Wizard selected.
Normally I double click New with wizard bit. Now using simple
Microsoft Graph Chart. Job done!

 

[Crystal (strive4peace)]

glad you got it Lester

The RecordSource is where the data comes from -- it is a
Property that can be set. The wizard asks you questions so
it can construct this for you.

Read the Properties and Methods section in Access Basics --
link in my siggy)

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
have an awesome day
*

? Thanks