| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do re-order values assigned by Excel for chart data?
I am creating a chart to compare values year over year. Ordering in the
worksheet reads Dec-Jan Left to Right. When I select the series in chart wizard, excel is assigning Jan as value 12, Feb as value 11, etc with Dec as 1. Then I attempt to add Jan and Feb of 2006 and it assigns Feb as value 1 and Jan as value 2---therefore comparing it to Dec and Jan of 2005. Any ideas on how to change the way excel is reading these values? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Can't get data from a web page to chart in excel. Any solutions? | Charts and Charting in Excel | |||
| How do I eliminate duplicate values in a series of data in excel? | Excel Discussion (Misc queries) | |||
| Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
| Get excel to list values that occur within raw data | Excel Discussion (Misc queries) | |||
Threaded Mode
