View Single Post
  #4  
Old March 10th, 2010, 07:25 PM posted to microsoft.public.excel.charting
Tiffany
external usenet poster
 
Posts: 148
Default Source data - have X and Y values for 1 series

And I should clarify that on the graph that I'm trying to duplicate when I go
to Source Data and click on the series for the columns it only gives me the
options to enter data for the Name and Values, but when I click on the series
for the line it gives me options to enter data for the Name, X Values AND Y
Values.

Thanks for your help!

-Tiffany


"Tiffany" wrote:

Ok I looked at changing it to an XY scatter chart but I don't see how that
gives me the option to have columns for one series and a line for another.....


"Luke M" wrote:

You're confusing a "line chart" with an "XY scatter chart".

--
Best Regards,

Luke M
"Tiffany" wrote in message
...
Someone before me had created a chart with columns and a line, but what I
can't figure out is how they made the line the way it is. When I go to the
Source Data the data series for the line has both an "X Values" and a "Y
Values". When I try to duplicate this in a new chart I only have the
option
to enter X Values. Any idea how to get it to give me a space to enter a Y
Value?



.