Pivot Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 07 Sep 2007 23:56 GMT

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

Reply to this Message

Debra Dalgleish - 08 Sep 2007 20:00 GMT

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.

> 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
[quoted text clipped - 4 lines]
>
> Paul

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message