![]() |
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 |
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