ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel 2003 plotting graphs in inverse order (https://www.excelbanter.com/charts-charting-excel/92700-re-excel-2003-plotting-graphs-inverse-order.html)

jsking

Excel 2003 plotting graphs in inverse order
 

Excel 2003 is plotting any type of graph I select in reverse order. I am
selecting data ranges normally, yet Excel is creating these upside down
graphs. I thought perhaps I'd inadvertantly changed a setting and tried
selecting "Default formatting" on chart type selection, but the default
is this inverse plotting!! I can select the axis(es) and select plot in
reverse order, which generally addresses my problem, except that then
the X-axis label winds up on top of the graph. Plot in reverse order
does not fix my root problem, which is that the darn thing is plotting
EVERYTHING inversely as the default. What's going on here?


--
jsking
------------------------------------------------------------------------
jsking's Profile: http://www.excelforum.com/member.php...o&userid=35188
View this thread: http://www.excelforum.com/showthread...hreadid=549514


Jon Peltier

Excel 2003 plotting graphs in inverse order
 
Did you add a custom chart type with reverse order plotting, then make it
the default?

Select a chart, go to Chart menu Chart Type Custom Types tab, click User
Defined at the bottom left, and check what appears in the list on the left.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jsking" wrote in
message ...

Excel 2003 is plotting any type of graph I select in reverse order. I am
selecting data ranges normally, yet Excel is creating these upside down
graphs. I thought perhaps I'd inadvertantly changed a setting and tried
selecting "Default formatting" on chart type selection, but the default
is this inverse plotting!! I can select the axis(es) and select plot in
reverse order, which generally addresses my problem, except that then
the X-axis label winds up on top of the graph. Plot in reverse order
does not fix my root problem, which is that the darn thing is plotting
EVERYTHING inversely as the default. What's going on here?


--
jsking





All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com