| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XY Scatter Chart in Excel 2007 - Cant Reverse Values
Thank you so much Jon....it worked
"Jon Peltier" wrote: You have to not only reverse the order, but change the Crosses At Maximum setting. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - Training in Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Marilyn" wrote in message ... Hi Jon, Thank you for the suggestion. We tried what you suggested and added a Secondary Category Axis, however, when we choose to Reverse the values Excel still shows everything on one side of the chart. Any ideas what we could have done wrong? Thanks "Jon Peltier" wrote: The two versions of Excel are more like cousins than like siblings. Instead of a few minor differences, there are more differences, and they sometimes are more striking. By rights, the secondary axis shouldn't move in 2003, either, since you've made no explicit changes to the secondary category axis (can't even see it). At times when Excel tries to figure out how to do what the user expects, I've found that 2003 does more things as one would expect; 2003 is a bit more flexible and a bit more intuitive in its behaviors. When things like this happen you will have to take extra measures to explicitly make changes. First you need to add the secondary category axis, then format it to position the secondary value axis, then remove the secondary category axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Marilyn" wrote in message ... Hello, I have a user in my group with an XY Scatter chart created in Excel 2007. When selecting the Category Axis and applying the "Values in Reverse Order" option, the Value Axis on the Left jumps to the right, however, the Value Axis on the right stays on the right instead of moving to the left. I tested this in Excel 2003 with no problems, is there something in Excel 2007 that would prevent this? Any Help Suggestion would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 XY Scatter Chart | Excel Discussion (Misc queries) | |||
| Is it possible to drag points in an Excel 2007 Scatter Chart? | Charts and Charting in Excel | |||
| Connecting two series in a scatter chart - Excel 2007 | Charts and Charting in Excel | |||
| Excel 2007: continuously update scatter chart from scroll bars | Excel Discussion (Misc queries) | |||
| BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) | |||
Hybrid Mode
