![]() |
simple chart question
I have data in cells g10:P10. I am trying to set up a simple line chart
however I would like the line chart to take the values in the opposite order than what it typically takes the data. example: the first value on the left side of the chart should be the value in cell P10(not G10), then O10, N10 etc. I have followed the instructions in "charting" but the horizontal (lower)axis values always end up in the order of G10:P10 and not P10:G10. I hope I have explained this properly. Thanks for your assistance. -- Shooter |
Format the X axis and select the SCALE tab. Select Categories in Reverse
order. "Shooter" wrote: I have data in cells g10:P10. I am trying to set up a simple line chart however I would like the line chart to take the values in the opposite order than what it typically takes the data. example: the first value on the left side of the chart should be the value in cell P10(not G10), then O10, N10 etc. I have followed the instructions in "charting" but the horizontal (lower)axis values always end up in the order of G10:P10 and not P10:G10. I hope I have explained this properly. Thanks for your assistance. -- Shooter |
All times are GMT +1. The time now is 10:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com