Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Simple chart | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel |