If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
[XY Scatter Charts] strange problems with X Axis data
Hi,
this is my first post on this newsgroup... so i introduce myself: i'm a IT technician and i work for an italian enterprise (so sorry for my poor english). I experienced a strange problem with excel 2000: when i try to ceate a XY scatter chart, Y series looks correct, but X series (data type is number) is taken like text. Eg: X Y 1.5 5.3 2.3 11.4 blank cell blank cell blank cell blank cell 7.8 18.4 23.8 3.4 (these data are selected using ctrl) in the chart i see correctly Y but X values a 1 2 3 4 and not 1.5 2.3 7.8 23.8 these values appears in the labels of the points. If i change chart type... the chart is correct (both x and y are correct) Someone can help me?? Thanks in advance. G |
#2
|
|||
|
|||
My guess is that the "blank cells" are not really blank, but have a null
string instead. Delete the contents of the "blank" x-cells. Jerry Gunjii wrote: Hi, this is my first post on this newsgroup... so i introduce myself: i'm a IT technician and i work for an italian enterprise (so sorry for my poor english). I experienced a strange problem with excel 2000: when i try to ceate a XY scatter chart, Y series looks correct, but X series (data type is number) is taken like text. Eg: X Y 1.5 5.3 2.3 11.4 blank cell blank cell blank cell blank cell 7.8 18.4 23.8 3.4 (these data are selected using ctrl) in the chart i see correctly Y but X values a 1 2 3 4 and not 1.5 2.3 7.8 23.8 these values appears in the labels of the points. If i change chart type... the chart is correct (both x and y are correct) Someone can help me?? Thanks in advance. G |
#3
|
|||
|
|||
mmmhh...
i haven't selected the blank cells... i've used 'ctrl' key to skip those cells. thanks for your reply G "Jerry W. Lewis" wrote: My guess is that the "blank cells" are not really blank, but have a null string instead. Delete the contents of the "blank" x-cells. Jerry |
#4
|
|||
|
|||
Did you really make a scatter chart, or is it a line chart? A line chart doesn't
care what the values are, it just plunks them down as text labels along the axis. The difference between Scatter and Line charts is in the axis behavior, not in how the points may be formatted, so it's generally preferable to make a Scatter chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Gunjii wrote: Hi, this is my first post on this newsgroup... so i introduce myself: i'm a IT technician and i work for an italian enterprise (so sorry for my poor english). I experienced a strange problem with excel 2000: when i try to ceate a XY scatter chart, Y series looks correct, but X series (data type is number) is taken like text. Eg: X Y 1.5 5.3 2.3 11.4 blank cell blank cell blank cell blank cell 7.8 18.4 23.8 3.4 (these data are selected using ctrl) in the chart i see correctly Y but X values a 1 2 3 4 and not 1.5 2.3 7.8 23.8 these values appears in the labels of the points. If i change chart type... the chart is correct (both x and y are correct) Someone can help me?? Thanks in advance. G |
#5
|
|||
|
|||
hi,
the same chart on another PC looks right! G "Jon Peltier" wrote: Did you really make a scatter chart, or is it a line chart? A line chart doesn't care what the values are, it just plunks them down as text labels along the axis. The difference between Scatter and Line charts is in the axis behavior, not in how the points may be formatted, so it's generally preferable to make a Scatter chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Gunjii wrote: Hi, this is my first post on this newsgroup... so i introduce myself: i'm a IT technician and i work for an italian enterprise (so sorry for my poor english). I experienced a strange problem with excel 2000: when i try to ceate a XY scatter chart, Y series looks correct, but X series (data type is number) is taken like text. Eg: X Y 1.5 5.3 2.3 11.4 blank cell blank cell blank cell blank cell 7.8 18.4 23.8 3.4 (these data are selected using ctrl) in the chart i see correctly Y but X values a 1 2 3 4 and not 1.5 2.3 7.8 23.8 these values appears in the labels of the points. If i change chart type... the chart is correct (both x and y are correct) Someone can help me?? Thanks in advance. G |
#6
|
|||
|
|||
I fixed the problem reinstalling Office... but i still have no idea why only on scatter charts excel failed. G |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
How do I put a gap between 2 data sets on the x axis? | Jon Peltier | Charts and Charting | 1 | April 19th, 2004 12:57 AM |
Data labels in scatter charts | Joshua | Charts and Charting | 1 | April 17th, 2004 06:55 PM |
force graph to axis of choice | bbxrider | Charts and Charting | 2 | February 12th, 2004 09:51 PM |
data to chart on primary axis | jw | Charts and Charting | 6 | September 24th, 2003 12:46 AM |