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

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote