ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   simple chart question (https://www.excelbanter.com/excel-worksheet-functions/37144-simple-chart-question.html)

Shooter

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

Barb Reinhardt

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