Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to insert a CHART into a Report but the labels always come up
with East, West, etc. The data appears to be fine but I don't understand why
the labels do not reflect what I want to see. The query that this chart is
based on looks fine. The Query is based on two tables. One is a lookup
table that contains a field used for the chart. The Master table called
Investigation tbl contains the data and specifically a field called
RequestType which draws its information from a Lookup table called
RequestType tbl. The chart draws from the Investigation tbl field called
Hours for a SUM calculation for the chart. The Type field in RequestType is
used to categorize the Hours field in a pie chart. But, the end result is a
pie chart with labels called East, west, etc.
 
Pearl,
A known pain in the neck with charts!
I think I got this trick from Duane Hookom...

Run the query behind the Chart.
Use Ctrl-A to select all the records.
Use Ctrl-Insert to COPY all the data.
Go to the spreadsheet associated with the chart.
Select the Home Button (very upper left of the spreadsheet)
Use Shift-Insert to Paste the query data.
That should "wake up" the spreadsheet.
hth
Al Camp
 
one question: what do you mean by "query behind the chart". I'm thankful
that someone else has seen this problem
 
That would be the RowSource property of the chart. That is usually a query.
It can be a table, and if so, use the same procedure, but with all the table
records Copied and Pasted.

Al Camp
 
Back
Top