Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Charts in a report (NT4.0 running office 2000)

    I am a little confused. I have added a chart to a report using the chart wizard and the data looks ok but I wanted to make some minor formatting changes. I opened the report in design view to access the chart, and all I see is what appears to be an example of a chart withjout my data. I tried to double click and open the chart control from the design view of the report but cannot get to my data. Am I missing anything. I looked at the data tab in the properties and can see that the information is coming from my tables and they are the correct tables I want to use but the graphic representation in the design view is not my data. Can someone help me understand this control a little better? Thank You
    Kevin

  2. #2
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts in a report (NT4.0 running office 2000)

    This is something I wish thy'd changed from '97, but as usual, they didn't bother. Anyway, what you see in Design view IS just a sample; you have to go back into view mode to see the REAL changes. I spent hours doing that 2 years ago, when I had a sub-report with another chart too.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Charts in a report (NT4.0 running office 2000)

    I bumped into this the other day. What I found was that a chart in a form is much easier to manipulate than a chart in a report. In a form, it behaves like a chart in Excel.
    So my solution was to place the chart in a form, play around with the formatting and when I was finally happy with it, save it as a report.
    Regards
    John



  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Charts in a report (NT4.0 running office 2000)

    Thank You very much! I will try the form approach. At least I know I was not seeing things.
    Kevin

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts in a report (NT4.0 running office 2000)

    I agree this is one of those things I to wish they would change. There is nothing wrong with making a chart in a report, in fact I prefer it, and its something I want to email with text as in letter format. However, the view "LIES" to you. When you double-click, you are in the mode that "does" let you change things, and the idea is to "go ahead" and change them, however you want. The bad part is, you have to back out and look at it in "print preview" to see how those changes actually look like. Very neanderthal to say the least. But it can be done, and you were doing it correctly.
    NMPadgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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