descending graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yusiye@gmail.com - 11 Jun 2007 16:35 GMT

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)

Reply to this Message

Ron Coderre - 11 Jun 2007 16:51 GMT

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

> 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
[quoted text clipped - 8 lines]
> Prtn Coord & RO Mngt","OF & PMO","Strtgy & Plan","VFI","Other"},'Data-
> Demographic'!$E$220:$S$220,1)

Reply to this Message

Rate this thread: