ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Desending Order (https://www.excelbanter.com/charts-charting-excel/157875-desending-order.html)

CS043 via OfficeKB.com

Desending Order
 
I have a graph set up to display names and test scores. How do I get the
graph to display the scores in descending order and move the names with it?

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200709/1


Andy Pope

Desending Order
 
Hi,

Charts just report the data. If you want it sorted then perform the sort
in the worksheet. Either directly on the data or if the data must remain
unsorted on a copy of the data used simply for charting.

Cheers
Andy

CS043 via OfficeKB.com wrote:
I have a graph set up to display names and test scores. How do I get the
graph to display the scores in descending order and move the names with it?

Thanks


James Silverton[_2_]

Desending Order
 
"CS043 via OfficeKB.com" <u17470@uwe wrote in message
news:7811663f7f434@uwe...
I have a graph set up to display names and test scores. How do
I get the
graph to display the scores in descending order and move the
names with it?

Thanks


Wouldn't sorting the underlying data do the job?



--
James Silverton
Potomac, Maryland



All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com