Chart display in design view

  • Thread starter Thread starter Averil Pretty
  • Start date Start date
A

Averil Pretty

Hello,

I am wanting to insert a chart into a report... I have
used the wizard to get all the data etc which is fine.
the problem I have is with the formatting.

I change a few formatting things in design view and then
preview it, and in the preview I can see it generally how
I want it to be. But when I go back to design view to
tweak a few things the bar graph that is displayed is the
generic Access one (e.g. East, West North).

I do have another question... In Excel you can choose the
source and have any number of "Series" for the graph but I
cant see how this is done in Access using the normal
charts. I need to have a line graph with several series
on it comparing against averages etc.

I have a feeling that it could be done with Pivot charts
but I'm not familiar with them... but if you can tell me
if I'm on the right track then I'll look into it more :-)

Thanks in advance.

Kind regards,
Averil Pretty
 
Hello,

I am wanting to insert a chart into a report... I have
used the wizard to get all the data etc which is fine.
the problem I have is with the formatting.

I change a few formatting things in design view and then
preview it, and in the preview I can see it generally how
I want it to be. But when I go back to design view to
tweak a few things the bar graph that is displayed is the
generic Access one (e.g. East, West North).

I do have another question... In Excel you can choose the
source and have any number of "Series" for the graph but I
cant see how this is done in Access using the normal
charts. I need to have a line graph with several series
on it comparing against averages etc.

I have a feeling that it could be done with Pivot charts
but I'm not familiar with them... but if you can tell me
if I'm on the right track then I'll look into it more :-)

Thanks in advance.

Kind regards,
Averil Pretty
Click to expand...

Always create your chart on a form first.
When the chart is working as you wish it, in design view copy the
chart and then paste it into the report.
Now it will show the actual chart in design view, not the generic as
it now does.
 
Thanks Fred :-)
-----Original Message-----


Always create your chart on a form first.
When the chart is working as you wish it, in design view copy the
chart and then paste it into the report.
Now it will show the actual chart in design view, not the generic as
it now does.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top