S
Steihl
Greetings...
I manage a database for a transportation company that contains several
fields, I'm using queries to build PivotCharts to serve as Key Performance
Indicators..
I can manuall go in and use drop fields to get the seperate charts I
need.. (i.e. Managed loads by carrier.. and managed loads by facility...)
However, there is certain data I need to exclude.. or, when dealing with
literraly hundreds or thousands of different customer drop locations, I need
to have it so that a different associate can go into the database, search for
a customer or carrier name (this much I know how to do) and after entering
the customer or carrier name, or even a date range and a by facility, or by
carrier report, show up so that standard formatting is applied to this chart..
e.g. I need data labels to appear automatically, and have them
automatically formatted. I need category bars shaded to certain patterns and
colors by default... I've had this work from a macro that simply opens the
query with filtered data to a presaved pivotchart view.. However, say my
associate searched for loads by facility by ZIPCODE.. the next time he goes
in, if he enters another zip code, then the chart loses most of it's
formatting: The Data labels dissappear.. Certain areas contain more load
types than another, so if the new location by zip contains a different type
of load, it loses all base formatting.
Anyone know a work around for this?
I manage a database for a transportation company that contains several
fields, I'm using queries to build PivotCharts to serve as Key Performance
Indicators..
I can manuall go in and use drop fields to get the seperate charts I
need.. (i.e. Managed loads by carrier.. and managed loads by facility...)
However, there is certain data I need to exclude.. or, when dealing with
literraly hundreds or thousands of different customer drop locations, I need
to have it so that a different associate can go into the database, search for
a customer or carrier name (this much I know how to do) and after entering
the customer or carrier name, or even a date range and a by facility, or by
carrier report, show up so that standard formatting is applied to this chart..
e.g. I need data labels to appear automatically, and have them
automatically formatted. I need category bars shaded to certain patterns and
colors by default... I've had this work from a macro that simply opens the
query with filtered data to a presaved pivotchart view.. However, say my
associate searched for loads by facility by ZIPCODE.. the next time he goes
in, if he enters another zip code, then the chart loses most of it's
formatting: The Data labels dissappear.. Certain areas contain more load
types than another, so if the new location by zip contains a different type
of load, it loses all base formatting.
Anyone know a work around for this?