Pivot Chart Format

[Keith]

I have created a pivot chart which consists of 4 sales areas by month, I
have displayed this as a stacked bar chart, however, I would like to see the
sales areas with the higher volumes at the bottom of the bars and the areas
with lower volumes at the top of the bars, each month the results are fairly
consistent with regards to the best and worst sales areas. So to clarify I
have sales areas A to D with sales volumes of 1000, 150, 200, 1750
respectively, this is how they appear on the chart but I would like to be
able to re-arrange the layout to show them in the order D, A, C, B, is this
possible and how?

Thanks

Keith

 

[Keith]

Can anyone help with this please?

 

[BruceM]

Can you sort by the sales volume? Are you using a query as the data source
for the chart? I can't sort out from your description just what is going
on. It sounds as if a number (dollars or whatever the numbers represent) is
on one axis, and there is one stacked bar per month, so I expect month is
the other axis. If so, you may need a separate chart for each month, as I
doubt you can rearrange the ordering of the results within a single data
source (chart source data). I haven't worked with pivot charts very much,
and there does not seem to be much documentation beyond creating charts for
the Northwinds database, so I freely admit I'm speculating a bit here.

 

[Keith]

The data is in a table, appended daily as the example below,

Area Date Sales
A 1/03/2007 100
B 1/03/2007 120
C 1/03/2007 20
D 1/03/2007 50

etc, do you think that running a sorted query on the table and using that as
the data source may help? I will give it a try..