Hi, I'm working on a excel file, and need to create a bar chart based
on the graph, it has to be descending on the graph, I made couple try
but no success. I'm lost on this topic. How to create a descending bar
chart?
Thank you.

Following is the chart formula:

=SERIES(,{"Advoc & Policy","Audit & Eval","Chld in Mnstry","Christian
Commit","Comms & Mrkt","DFR","Finance","HEA","HR","IT","Off Prsd &
Prtn Coord & RO Mngt","OF & PMO","Strtgy & Plan","VFI","Other"},'Data-
Demographic'!$E$220:$S$220,1)

A descending value bar chart is one of the major features of a Pareto Chart
(which my company uses regularly).

Debra Dalgleish was kind enough to offer my automated version at her website:

http://www.contextures.com/excelfiles.html
(See the Charts section)

That file automatically rearranges and resizes the chart to accommodate the
data.

Is that something you can work with?

(Post back with more questions)
***********
Regards,
Ron

XL2002, WinXP


"(E-Mail Removed)" wrote:

> Hi, I'm working on a excel file, and need to create a bar chart based
> on the graph, it has to be descending on the graph, I made couple try
> but no success. I'm lost on this topic. How to create a descending bar
> chart?
> Thank you.
>
> Following is the chart formula:
>
> =SERIES(,{"Advoc & Policy","Audit & Eval","Chld in Mnstry","Christian
> Commit","Comms & Mrkt","DFR","Finance","HEA","HR","IT","Off Prsd &
> Prtn Coord & RO Mngt","OF & PMO","Strtgy & Plan","VFI","Other"},'Data-
> Demographic'!$E$220:$S$220,1)
>
>