Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Scatter Diagrams
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Scatter Diagrams
 |
Scatter Diagrams |
|
|
Thread Tools | Rate Thread |
04-07-2008, 03:50 PM
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
|
04-07-2008, 06:44 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: 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" <Greener2224@discussions.microsoft.com> wrote in message news:1C5BDBF4-9411-49F5-AB4D-5B31AF3E919B@microsoft.com... > 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 |
|
|
|
05-07-2008, 01:59 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: 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" <Greener2224@discussions.microsoft.com> wrote in message > news:1C5BDBF4-9411-49F5-AB4D-5B31AF3E919B@microsoft.com... > > 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 > > > |
|
|
|
05-07-2008, 03:10 PM
|
#4 |
|
Guest
Posts: n/a
|
Re: 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" <Greener2224@discussions.microsoft.com> wrote in message news:70E7506A-203A-41F8-A7EF-7CDA4E4778FF@microsoft.com... >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" <Greener2224@discussions.microsoft.com> wrote in message >> news:1C5BDBF4-9411-49F5-AB4D-5B31AF3E919B@microsoft.com... >> > 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 >> >> >> |
|
|
|
05-07-2008, 03:34 PM
|
#5 |
|
Guest
Posts: n/a
|
Re: 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" <Greener2224@discussions.microsoft.com> wrote in message > news:70E7506A-203A-41F8-A7EF-7CDA4E4778FF@microsoft.com... > >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" <Greener2224@discussions.microsoft.com> wrote in message > >> news:1C5BDBF4-9411-49F5-AB4D-5B31AF3E919B@microsoft.com... > >> > 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 > >> > >> > >> > > > |
|
|
|
05-07-2008, 05:31 PM
|
#6 |
|
Guest
Posts: n/a
|
Re: 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" <Greener2224@discussions.microsoft.com> wrote in message news:3AD05791-0B90-4553-914F-FEB83FA9350E@microsoft.com... > 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" <Greener2224@discussions.microsoft.com> wrote in message >> news:70E7506A-203A-41F8-A7EF-7CDA4E4778FF@microsoft.com... >> >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" <Greener2224@discussions.microsoft.com> wrote in message >> >> news:1C5BDBF4-9411-49F5-AB4D-5B31AF3E919B@microsoft.com... >> >> > 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 >> >> >> >> >> >> >> >> >> |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
