Microsoft Access Graph Sample Data

How can I view the actual data in Microsoft Access graphing tool. In my report design view it only shows sample data.
RS4823Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick67Commented:
Chart Objects are a bit odd.
One of the very first things to do with a Chart object is give it a sane RowSource, because what the wizard tries to generate is rarely what you actually want.
The data the chart will use is whatever the .RowSource property is.
You can view that query through the Properties | RowSource of the Chart Object.

You can open or edit the Chart object itself, but as you have seen, that rarely presents the data you think it will.
It turns out Charts are 'sticky'
Whatever edits you do to them either via GUI or VBA stick and are permanent, unlike manipulations of forms or reports, which if the VBA is altered change, and if the VBA is removed go back to a default state.

A Chart's default state is whatever was working at the last time it was rendered.
0
hnasrCommented:
What I found:
Because access is an interpreted language, it takes care of the chart output.
To show the result in the datasheet, do the following steps.
 
Edit chart.
Select View>Datasheet
Modify column headings to correspond to what in Row Source select statement.
Delete any extra columns.
Delete nonsense data in category axis.
Exit access
Reopen access and run report.
 
Datasheet should display relevant data.

The last statement of Nick67's comment is interesting.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nick67Commented:
We were poking charts with a stick here
http://www.experts-exchange.com/questions/28687999/Access-VBA-chart-list-of-methods-functions.html

I added a little VBA things to my Chart

With Me.grphLoadTest.Object
    .Axes.Item(xlValue).MaximumScale = ChartMaxVal
    .Axes.Item(xlCategory).MaximumScale = ChartMaxCategory
'additions
    .HasTitle = True
    .ChartTitle.Text = "Preview of " & Forms!frmPressuretest!lstPossibleImports.Value
    .Axes.Item(xlValue).TickLabels.NumberFormat = "0%"
    .Axes.Item(xlValue).TickLabels.Font.ColorIndex = 3
'end additions
End With

Now with an Access object if you comment out the lines, one expects that the title would go away, have no string value, the axes would have no number value and return to a default color.

That's not what happens with a Chart.
Instead, those four settings persist until altered in VBA or altered by editing the Chart object itself.
Whatever is last successfully rendered persists.

That was quite unexpected.
I really wasn't looking to CHANGE my Chart permanently -- but I did, at run-time with the VBA posted.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.