| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scatter Diagrams
The x values will not display properly. They just plot as if they were the
numbers 1 2 3 etc but the y values are fine. If I make the reverse the x and y data the graph works but is of course not in the format I want Suggestions please |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Scatter Diagrams
Use the XY chart type, not the line type, and make sure the chart is using
the X data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Greener2224" wrote in message ... The x values will not display properly. They just plot as if they were the numbers 1 2 3 etc but the y values are fine. If I make the reverse the x and y data the graph works but is of course not in the format I want Suggestions please |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Scatter Diagrams
I was using the xy chart but the x values were not plotting correctly the
were acting as if the wer the numbers 1,2,3,4..... "Jon Peltier" wrote: Use the XY chart type, not the line type, and make sure the chart is using the X data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Greener2224" wrote in message ... The x values will not display properly. They just plot as if they were the numbers 1 2 3 etc but the y values are fine. If I make the reverse the x and y data the graph works but is of course not in the format I want Suggestions please |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Scatter Diagrams
Make sure the chart is using the correct data for its X values.
Make sure these data are truly numeric, and not numbers stored as text. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Greener2224" wrote in message ... I was using the xy chart but the x values were not plotting correctly the were acting as if the wer the numbers 1,2,3,4..... "Jon Peltier" wrote: Use the XY chart type, not the line type, and make sure the chart is using the X data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Greener2224" wrote in message ... The x values will not display properly. They just plot as if they were the numbers 1 2 3 etc but the y values are fine. If I make the reverse the x and y data the graph works but is of course not in the format I want Suggestions please |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Scatter Diagrams
Done all of that if I reverse my selection of data for x and y the graph
works perfectly but has the wrong orientation "Jon Peltier" wrote: Make sure the chart is using the correct data for its X values. Make sure these data are truly numeric, and not numbers stored as text. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Greener2224" wrote in message ... I was using the xy chart but the x values were not plotting correctly the were acting as if the wer the numbers 1,2,3,4..... "Jon Peltier" wrote: Use the XY chart type, not the line type, and make sure the chart is using the X data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Greener2224" wrote in message ... The x values will not display properly. They just plot as if they were the numbers 1 2 3 etc but the y values are fine. If I make the reverse the x and y data the graph works but is of course not in the format I want Suggestions please |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Scatter Diagrams
Okay, I'll bite. Send a copy of the errant worksheet to me in an email to
jonxlmvp at peltiertech dot com I'll take a look. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Greener2224" wrote in message ... Done all of that if I reverse my selection of data for x and y the graph works perfectly but has the wrong orientation "Jon Peltier" wrote: Make sure the chart is using the correct data for its X values. Make sure these data are truly numeric, and not numbers stored as text. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Greener2224" wrote in message ... I was using the xy chart but the x values were not plotting correctly the were acting as if the wer the numbers 1,2,3,4..... "Jon Peltier" wrote: Use the XY chart type, not the line type, and make sure the chart is using the X data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Greener2224" wrote in message ... The x values will not display properly. They just plot as if they were the numbers 1 2 3 etc but the y values are fine. If I make the reverse the x and y data the graph works but is of course not in the format I want Suggestions please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nyquist diagrams | Charts and Charting in Excel | |||
| Pie Diagrams | Charts and Charting in Excel | |||
| Radial diagrams | Charts and Charting in Excel | |||
| Diagrams | Excel Discussion (Misc queries) | |||
| Labels for Scatter Diagrams | Charts and Charting in Excel | |||
Linear Mode
