How do I create more than one chart in Access?

G

Guest

hello

I am a newbie to Accesss. I am simply looking to create a few charts using
the database fields. I have created one chart using PivotChart - to find
say total traffic on all the nodes.

Now I want to create graphs for individual nodes and their traffic.

I want to create it on a separate View like in EXcel - you can create
separate chart - which t hen opens a new page.

How do I do that in Access? Only option seems Multiplot /Multiplot Unified
Scale - which keeps expanding the same chart View.

I want to keep the first chart, open a new page and create new charts.

Help!

Thanks
 
S

Stephen Glynn

If I understand the question correctly, I think you could create a
series of separate queries to return the data you want to plot in each
the graphs.

If you want to display the charts on a form, you can then create an
unbound form (i.e. one without a data source) and use the tab tool to
insert as many pages as you have charts. Then use the Chart tool to
drop one chart, based on the appropriate query, onto each tab.

If you want to display them in a printed report, create an unbound
report and drop them in the detail section, inserting page breaks where
appropriate.

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top