B
Bobk
Help! I have been struggling trying to put a chart into a report. I create a
report and insert a chart. All I want to do is plot months on the X axis and
% from 0 to 100 on the Y axis. I have data for several vendors, by month ,
with data for on time delivery of goods. There is a single entry for each
vendor for each month representing their performance for the month. I select
the individual vendors and the date range via a form. The source data for the
chart is in a resulting query. I don't understand why the chart forces a sum
for the performance data in the query. Why can't I just plot a simple 2 axis
plot of data by month and %? And what is the the report data sheet that keeps
popping up with Qtr data and East, West etc?
Can someone explain it's purpose and how it is supposed to be used?
Is there a place where I can find complete and detailed instructions on how
to use the Access Chart feature?
Considering that Access is a pretty good productivity tool this simple chart
feature is not in keeping with the rest of the product. I would suggest that
Microsoft spend a little effort and get this feature up to speed. I don't
want to have to spend endless hours trying to implement a simple chart into a
report and, what's so frustrating, there doesn't seem to be any comprehensive
literature available descrbing how to gain control of this feature. HELP!
report and insert a chart. All I want to do is plot months on the X axis and
% from 0 to 100 on the Y axis. I have data for several vendors, by month ,
with data for on time delivery of goods. There is a single entry for each
vendor for each month representing their performance for the month. I select
the individual vendors and the date range via a form. The source data for the
chart is in a resulting query. I don't understand why the chart forces a sum
for the performance data in the query. Why can't I just plot a simple 2 axis
plot of data by month and %? And what is the the report data sheet that keeps
popping up with Qtr data and East, West etc?
Can someone explain it's purpose and how it is supposed to be used?
Is there a place where I can find complete and detailed instructions on how
to use the Access Chart feature?
Considering that Access is a pretty good productivity tool this simple chart
feature is not in keeping with the rest of the product. I would suggest that
Microsoft spend a little effort and get this feature up to speed. I don't
want to have to spend endless hours trying to implement a simple chart into a
report and, what's so frustrating, there doesn't seem to be any comprehensive
literature available descrbing how to gain control of this feature. HELP!