Results 1 to 11 of 11

Thread: MS Graph (2000)

  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS Graph (2000)

    Is this possibly the most difficult program to work with? I went through Chart Wizard to get a graphed report and I am unable to make any modifications to this report! Are there any workarounds that people have come up with? I want to resize the legend (which looks fine in the design mode, but when I hit the print preview button it becomes HUGE) and reverse the order of the X-axis.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Graph (2000)

    Charts in forns and reports are notoriously difficult to work with, but is is possible to get very good results with some practice. Make liberal use of backup copies and of the undo feature.

    Open the report in design view.
    Select the chart by clicking it once.
    Check the SizeMode property - it can be set to Stretch, Clip and Zoom; the default value is Stretch, but you may prefer Zoom or Clip - experiment by changing the value and switching to Preview mode.
    To edit the chart itself, double click it (in design view); you can now edit the properties of the background, the axes etc. by double clicking them. Once you're done, click outside the chart.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Graph (2000)

    I can get it to look fine in design mode, but it doesn't seem to impact the actual report when I preview it, with the exception of resizing, colors, titles, etc. I've tried to modify the queries to change the order of the X-axis (it's going from earliest month to latest month, when I want it the opposite) but that doesn't seem to do anything.

    This is one instance in which I wish I had Access 2002!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Graph (2000)

    I have never used Access 2000, but although it is easier to edit charts in Access 2002 than in Access 97, the basic idea is the same, so I suppose it can't be all that different in Access 2000.

    Have you tried reversing the order of the x-axis by double clicking it and selecting "Categories in reverse order" in the Scale tab of the "Format Axis" dialog?

  5. #5
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Graph (2000)

    Bingo! Thanks Hans. One more thing: How do I format the Legend? Again, I can format it in design view, but it doesn't show up in the preview.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Graph (2000)

    How are you editing the legend? Are you setting the font, background or border of the legend as a whole, or are you editing individual legend entries? The first should work, the second could be tricky, since the series shown in design view may not correspond to the series you see in runtime.

    If you don't succeed in editing a chart interactively, you can do it in code. All aspects of a chart can be controlled using VBA. You can download a demo database from ACC97: Microsoft Access 97 Sample Graphs Available in Download Center. It is for Access 97, but the ideas behind it are valid in higher versions too.

  7. #7
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Graph (2000)

    Well, I'm really trying to EDIT the text in the legend -- I want the categories to say something different than what they say right now.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Graph (2000)

    Ah! You see, the problem is that the legend entries are created from the data, and the data are read anew each time you view the chart, so any manual changes will be overridden (frankly, I thought that you couldn't edit the captions at all.)
    So you must either ensure that the captions for the legend are taken from the data automatically, or use a completely different method. For instance, you could click outside of the chart, then place transparent text boxes or labels on top of the chart.

  9. #9
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Graph (2000)

    Gotcha! Thanks so much!

    One more question: I need to create the sum of a few fields. For example, if my database includes the number of peas, corn, and carrot shipments for each month, I want to sum the shipments for the month, and then add the peas, corn, and carrot sums together to track in a graph. So it's really summing twice. Am I am able to do that in Access? I don't think I can do it in a query. I tried creating a form with text boxes that created the sum in one different text box, but I'm not sure where to go from there.

    Thanks!!!! <img src=/S/bubbles.gif border=0 alt=bubbles width=31 height=17>

  10. #10
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: MS Graph (2000)

    How about building the report/chart from a query using aliases. That way if the actual field name is "wheat3" and you want the caption to be "Grapenuts" you use the Grapenuts: wheat3 syntax in the query grid (or is it [wheat3]?)

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Graph (2000)

    If you have a group by query with SumOfPeas: Sum([Peas]), SumOfCorn: Sum([Corn]) and SumOfCarrots: Sum([Carrots]), you can create another query based on the first one that includes SumOfPeas, SumOfCorn and SumOfCarrots and a new field SumOfVeggies: [SumOfPeas]+[SumOfCorn]+[SumOfCarrots]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •