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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |