A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I create more than one chart in Access?



 
 
Thread Tools Display Modes
  #1  
Old February 22nd, 2006, 03:38 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default How do I create more than one chart in Access?

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

  #2  
Old February 23rd, 2006, 05:12 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default How do I create more than one chart in Access?

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

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
is Access 2003 any better than XP? Gorb General Discussion 4 November 11th, 2004 09:44 PM
Upload Image Jason MacKenzie General Discussion 1 September 1st, 2004 04:38 AM
Useless Access 2003 tired, angry, sucidial and bored General Discussion 10 July 21st, 2004 11:52 PM
Need help: Can't create ADP Database in MSDE from MS Access Lou Arnold General Discussion 0 July 21st, 2004 04:54 AM
May you help me? output data MS Access query to excel and create chart. slim004 Charts and Charting 1 May 14th, 2004 11:34 AM


All times are GMT +1. The time now is 07:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.