Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Chart
I have a series of leased vehicles. I get their date & mileage from our gas
card company. I am able to use this information to create a graph of each vehicles mileage with a pivot chart. I want to superimpose based upon the particular vehicle a line showing the allowable mileage. My goal is to see if we are heading to using a vehicle for more or less miles than the lease allows. Paul |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Chart
You could add a field to the source data, and enter the mileage there.
Add that field to the pivot table's data area, and in the chart, change that series to a line chart type. When you update or change the pivot table or pivot chart, the formatting will be lost. You can record a macro as you format the series, and run that macro as required. Paul wrote: I have a series of leased vehicles. I get their date & mileage from our gas card company. I am able to use this information to create a graph of each vehicles mileage with a pivot chart. I want to superimpose based upon the particular vehicle a line showing the allowable mileage. My goal is to see if we are heading to using a vehicle for more or less miles than the lease allows. Paul -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create chart from Pivot table but not Pivot chart? | Charts and Charting in Excel | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
Maintain colour changes in a Pivot Chart when changing Pivot value | Charts and Charting in Excel | |||
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) |