Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Microsoft Graph - What is datasheet view about?

Posted on 2003-12-10
11
Medium Priority
?
1,483 Views
Last Modified: 2007-12-19
Hello!

I haven't spent much time playing with charts in Access, but tomorrow I am teaching a short class on the subject.  HELP!

I am working with some charts that I have created using the chart wizard and am working with them in "Microsoft Graph".  I am a VB developer and can usually figure this stuff out, but I can't figure out how to get my data to show in the datasheet view and the development chart.  Both the chart and datasheet show the default East, West, North / Qtr 1, Qtr 2... crap.  What is this about?

If anyone has any good links to Microsoft Access chart tutorials, directions, etc., please send them my way!

Thanks!
0
Comment
Question by:AirResourceSpec
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 3
11 Comments
 
LVL 8

Expert Comment

by:NowaY
ID: 9914401
I hate thse stupid charts....

Usually you can get the default crap out of there if you close the form and reopen it.

It is a terrible program. I think it is Microsoft's way of getting us to use Excel.
0
 
LVL 1

Author Comment

by:AirResourceSpec
ID: 9914470
Yea... I've got the "stupid" part figured out!
Anybody else have any insight???
0
 
LVL 8

Expert Comment

by:NowaY
ID: 9914505
Have you tried just inserting a blank object then changing it to a chart?
0
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 
LVL 8

Accepted Solution

by:
NowaY earned 375 total points
ID: 9914566
One way is to open your form/report in design view.  Open the property window of the chart and preview the row source ( follow the
dots to the design grid and view the data ) click the upper left cell to highlight all data and Ctrl-C.  Shut down the query grid
and edit the graph ( double click ), go to the datasheet, highlight all with a click to the upper left cell and Ctrl-V
0
 
LVL 1

Author Comment

by:AirResourceSpec
ID: 9914610
NowaY - That does what I want, but that is insanely clunky!  I can't believe there isn't a better way (I can believe it, I just don't want to!).  Anybody else have any easier ways?
0
 
LVL 8

Expert Comment

by:NowaY
ID: 9914619
I hate to say it, but that the limitation of the chart object. That's it.
0
 
LVL 8

Expert Comment

by:NowaY
ID: 9914750
You could maybe try the latest service packs, but they haven't helped me.
0
 
LVL 1

Author Comment

by:AirResourceSpec
ID: 9914949
Yea... I think I'm service packed out.  Thanks though!
0
 
LVL 2

Expert Comment

by:Phythaelic
ID: 9918254
I just finished a project on it, so your in luck.
Right click on the Chart, go to properties
Goto Data, Row Source.
Click on the Elipses (...), then view the datasheet.
File, Export, save as an Excel File.
Double Click the graph.
On the menu, Edit, Import Data
Select the Excel File you saved before.

If you want to doctor the data a little, edit it in excel before you import the data.

If you don't want to edit the data, export it as a TXT file instead.  A little more streamlined.   This is just for setup, so you can see an actual set of the data when you are setting the ranges and fonts, etc.

You can also link the chart to data by filtering data on your form and choosing fields (in the row source of the chart properties box).  Use the same table as the form source (or subform).  Then, when they view the form (with the chart), the chart will re-graph whenever the filtered data changes.

Also, if you want to set the ranges programmatically, be sure to include the reference to MS Graph 9.0.  Here is some sample code to set the axis ranges...
Function ()
    Dim GraphObj As Graph.Chart
    Dim xAxisChart As Graph.Axis

    Set GraphObj = Me.Graph0.Object  'Graph0 is the name of your graph object
    Set xAxisChart = GraphObj.Axes(xlValue)
    With xAxisChart
        If Me.PPMScale <> 0 Then
            .MinimumScale = 0 - Me.PPMScale 'PPMScale is an option box on the form to set the desired scale
            .MaximumScale = Me.PPMScale
            .MajorUnit = (Me.PPMScale) / 5
            If Me.PPMScale >= 50 Then
                .MinorUnit = (Me.PPMScale) / 25
            Else
                .MinorUnit = (Me.PPMScale) / 10
            End If
            .MaximumScaleIsAuto = False
            .MinimumScaleIsAuto = False
            .MinorUnitIsAuto = False
     end with
end function
0
 
LVL 2

Expert Comment

by:Phythaelic
ID: 9918311
OOps, for the code above to work, add an extra "End If" line before the "End With" statement.  This code changes the Y-axis values.  For more info, check out the following, but use graph.chart instead of Excel.Chart
msdn.microsoft.com
Office Solutions Development / Microsoft Office / Microsoft Office 2000 / Technical Articles / Automating Microsoft Office 97 and Microsoft Office 2000

It's a 123 page article, so for a quick reference, search for "xlvalue"
0
 
LVL 2

Expert Comment

by:Phythaelic
ID: 9987220
Just wanted to see if your question had been answered and could be closed.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question