Did it not appear at all, or was in not visible for some reason? Are the Y
values similar in magnitude to those of the columns already plotted?
In the dropdown that lets you see what chart element is selected, and select
other elements, can you see and select the new series? (I don't have 2007
right in front of me, but I think the dropdown is on the second and third of
the Chart Tools tabs.)
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Fabio Coatis" wrote in message
ups.com...
Hi Jon,
I just was following your directions using the column chart, but when
I was pasting special the sencondary axis data ( 0 and 1) the series
did not appear in the chart so that I couldnīt select it to change the
data type for xy scatter. Maybe I have an old version of XL 2007.
On 20 set, 16:37, "Jon Peltier"
wrote:
Sure it does. The various commands are no longer found on the familiar
toolbars and dialogs, but in general the protocol works fine.
Create a column chart.
Copy the XY data, Select the chart, Paste Special as New Series.
Convert added series to XY type.
Remove secondary Y axis, format secondary X axis.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______
"Fabio Coatis" wrote in message
oups.com...
Hi,
John Peltierīs method
(http://peltiertech.com/Excel/Charts/...orzSeries.html)
doesnīt work in xl 2007, any comments?
TIA