To display Line Graph using Pivot table data

To display Line Graph using Pivot table data

Post by Irene Ch » Sat, 12 Jul 2003 18:25:17



I have the following Access table:

DEPT_GROUP  BUDGET  ACTUAL PERIOD
----------  ------  ------ ------
HR          100000  80000  JUNE03
HR          100000  90000  JULY03
FINANCE     300000 200000  JUNE03
FINANCE     300000 280000  JULY03

I wish to create a Pivot Table in Excel 2000 that get the data from
the above table and display as a Pivot Table in Excel and at the
sametime display as the  following Line Graph by departmental basis:

DEPT: HR

       |
       |
100000 |    -------
 90000 |           *
 80000 |    *
       |
       |
       |
       |
       ---------------------------------------------------------
          JUN03  JUL03

Whereby, the X-axis will show the Period, and Y-axis will the the $
and two different lines - one show the Budgeted amt and the other line
show Actual amount.

Really appreciate any help in doing that, thanks.

Rgds,
Irene

 
 
 

1. Pivot Tables - How to display multiple data columns

Raw Data:
ID      Revenue Expense
1       200     40
1       205     60
2       210     20
3       190     25
2       182     80
1       135     32

I can display:
Pivot Table
ID      Sum of Revenue  
1       540    
2       392    
3       190    

I can display:
Pivot Table            
ID      Sum of Expense          
1       132    
2       100    
3       25      

HOW DO I DISPLAY ?????
Pivot Table            
ID      Sum of Revenue  Sum of Expense          
1       540             132    
2       392             100    
3       190             25

2. Fonts for Invoices

3. Hand coding of Pivot Tables - Problem with Pivot data field

4. Imagewriter II problem

5. Pivot table to remain intact - even if data table is removed

6. Breakpoints and threads

7. How to overlay regression line on graph using only part of data

8. CDR 102 firmware

9. dflo/dg compiler graph display/data flow equation display tool

10. Plotting multiple lines of data on one line in a graph

11. graphs from pivot tables, inserting error bars?

12. Excel data functions / Pivot Tables