Is there a way to make the scales the same for when you have column and
line data on one graph? Because, when I try and compare the two scales
(top to bottom) they don't match up exactly.
Is there a way to make the scales the same for when you have column and
line data on one graph? Because, when I try and compare the two scales
(top to bottom) they don't match up exactly.
If Excel has put one of the series onto the secondary axis, double click the
series, and on the Axis tab select Primary. This forces the series to use
the same axis.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
<Justin_Yuen@hotmail.com> wrote in message
news:1141316377.117528.205420@t39g2000cwt.googlegroups.com...
> Is there a way to make the scales the same for when you have column and
> line data on one graph? Because, when I try and compare the two scales
> (top to bottom) they don't match up exactly.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks