descending graph

  • Thread starter Thread starter yusiye
  • Start date Start date
Y

yusiye

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
 
Back
Top