View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day Kelly O'Day is offline
external usenet poster
 
Posts: 103
Default charting locations over time instead of numbers

Bullseye:

Send me your file and I'll take a look.

Here's my anti-spam e-mail - edit and send the file.

koday*at*processtrends*dot*com

Kelly

http://processtrends.com


"Bullseye" wrote in message
...
I tried that a few times, no help. I think I may be failing in a more
basic
way. According to what I see in your picture in the tutorial, it appears
that the source for the paste special (ie the selection I have copied at
the
time) are the column of zero's and the column of number series zero
through
whatever the number of rows I have...is this correct? Is there something
else I am missing? It seems so simple, yet everthing I do, it moves all
my
data plots into a vertical column. thoughts? Thanks again for your time
&
expertise!

"Kelly O'Day" wrote:

Bullseye:

On the Paste Special window Options:

1. Upper left: Check Add cells as: Select new series
2. Lower left: Check Categories (X values in First Column)
3. Replace Existing Categories: Uncheck Replace Existing Categories

....Kelly


"Del Cotter" wrote in message
...
On Sat, 17 Feb 2007, in microsoft.public.excel.charting,
Bullseye said:
This is a great option...just one problem. I have gone everything
thing
you
show in your examples...but for some reason I run into a problem in
step
4.
When I paste special, I get the vertical pight purple squares on the
y-axis,
but it also moves all my data points into a vertical column as well
instead
of leaving them where they were.

It sounds as if you've got the "Replace existing categories" box
checked.
Uncheck it to avoid the range of zeroes being used for every series
x-values.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3
instead.