ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Charts (https://www.excelbanter.com/excel-discussion-misc-queries/72199-charts.html)

SamGB

Charts
 

Is there anyway of getting a chart to show the data from highest to
lowest?
without rearanging the cells that contain the data or creating
duplicate cells to arrange accending??

Many thanks for your time


--
SamGB
------------------------------------------------------------------------
SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263
View this thread: http://www.excelforum.com/showthread...hreadid=513411


vezerid

Charts
 
The only case is with XY-Scatter charts. These assume that the second
column (Y) is a function of the first. If you choose marks only and no
line, then the (x,y) points will be shown in their proper places
regardless of order of the x points in your worksheet.

However! COntrary to other chart types (e.g. column chart), which space
all data points evenly across the horizontal axis, here the placement
of the marks will depend on the values of x along the x-axis.

HTH
Kostis Vezerides



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

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