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
|
|||
|
|||
x-y plots
How can I get a simple x-y plot? The wizard insists on grouping and summing
the data, which is not what I need. A search of this forum didn't shed any light on the subject. |
#2
|
|||
|
|||
x-y plots
Please post the SQL for the query in the RowSource property for the
chart. If there's an underlying query, post that SQL as well. LeAnne The Big Smelly Ogre wrote: How can I get a simple x-y plot? The wizard insists on grouping and summing the data, which is not what I need. A search of this forum didn't shed any light on the subject. |
#3
|
|||
|
|||
x-y plots
Here is the underlying query:
SELECT Resource, Latitude, Longitude FROM qryDeposits ORDER BY Resource; Here is the query that the wizrd places into the chart's Row Source: SELECT [Resource],Sum([Latitude]) AS [SumOfLatitude] FROM [qryGraph] GROUP BY [Resource]; What I want is a simple plot of latitude vs. longitude, with a different symbol for each resource. I can export the query to an Excel spreadsheet and plot it, but I would prefer to do it within Access. Eventually I want to be able to add controls to enble the control of the plotted range and scale, but I need to get the basic graph to work first. "LeAnne" wrote: Please post the SQL for the query in the RowSource property for the chart. If there's an underlying query, post that SQL as well. LeAnne The Big Smelly Ogre wrote: How can I get a simple x-y plot? The wizard insists on grouping and summing the data, which is not what I need. A search of this forum didn't shed any light on the subject. |
#4
|
|||
|
|||
x-y plots
Access wizards are often quite stupid. You'll find a workaround for the
pointless requirement to sum or otherwise aggregate chart data at http://www.cpcug.org/user/clemenzi/t...ss/Charts.html hth, LeAnne The Big Smelly Ogre wrote: Here is the underlying query: SELECT Resource, Latitude, Longitude FROM qryDeposits ORDER BY Resource; Here is the query that the wizrd places into the chart's Row Source: SELECT [Resource],Sum([Latitude]) AS [SumOfLatitude] FROM [qryGraph] GROUP BY [Resource]; What I want is a simple plot of latitude vs. longitude, with a different symbol for each resource. I can export the query to an Excel spreadsheet and plot it, but I would prefer to do it within Access. Eventually I want to be able to add controls to enble the control of the plotted range and scale, but I need to get the basic graph to work first. "LeAnne" wrote: Please post the SQL for the query in the RowSource property for the chart. If there's an underlying query, post that SQL as well. LeAnne The Big Smelly Ogre wrote: How can I get a simple x-y plot? The wizard insists on grouping and summing the data, which is not what I need. A search of this forum didn't shed any light on the subject. |
#5
|
|||
|
|||
x-y plots
Thanks for your help. I fully appreciate the time and effort that goes into
helping others in these forums. That said, I played with this all weekend, and it seems that the best I can get access to do at producing an x-y plot is really more of a bar chart without the bars. All of the x data must fall on a given, evenly spaced line. My data's not so neat. I need to plot what are essentially coordinates on a map, something like this: point x y 1 16542.0 8546.4 2 17634.5 6385.4 3 15964.8 7642.3 This is very easy to do in Excel, and I have set it up to plot my data. But, it would be much more useful to do it from within Access. And, since both programs use the same graphing system, it should be possible. The question is, how? "LeAnne" wrote: Access wizards are often quite stupid. You'll find a workaround for the pointless requirement to sum or otherwise aggregate chart data at http://www.cpcug.org/user/clemenzi/t...ss/Charts.html hth, LeAnne The Big Smelly Ogre wrote: Here is the underlying query: SELECT Resource, Latitude, Longitude FROM qryDeposits ORDER BY Resource; Here is the query that the wizrd places into the chart's Row Source: SELECT [Resource],Sum([Latitude]) AS [SumOfLatitude] FROM [qryGraph] GROUP BY [Resource]; What I want is a simple plot of latitude vs. longitude, with a different symbol for each resource. I can export the query to an Excel spreadsheet and plot it, but I would prefer to do it within Access. Eventually I want to be able to add controls to enble the control of the plotted range and scale, but I need to get the basic graph to work first. "LeAnne" wrote: Please post the SQL for the query in the RowSource property for the chart. If there's an underlying query, post that SQL as well. LeAnne The Big Smelly Ogre wrote: How can I get a simple x-y plot? The wizard insists on grouping and summing the data, which is not what I need. A search of this forum didn't shed any light on the subject. |
#6
|
|||
|
|||
x-y plots
BSO,
It's certainly possible. Did you go to the link I posted? There are pretty straightforward instructions on how to create an xy scatterplot. As I said before, the Access ChartWizard is stupid. I would only rely on the Wizard to throw a chart (any old chart) on my Form quickly. Then I prefer to modify the RowSource query, change the chart type etc. manually. Some thoughts: Are you sure your coordinates are really NUMBERS? Lats and longs (or UTMs, or other spatial data) aren't "numbers" in the sense that you can do math with them. After all, 16542.0 + 8546.4 doesn't produce anything meaningful. Access and MS Graph require at least 1 field to be numeric. Second (as was pointed out in the link), it's easy to modify the underlying query manually. Just remove the Sum() or other aggregate function from the SQL statement. You'll need to also delete the GROUP BY clause or you'll get an error. Finally, I'd suggest building your form, adding your chart, double-click on the chart to launch MS Graph, and plunging right in with the MS Graph Help file (table of contents). There's (surprise!) quite a bit of helpful information. I also searched Graph Help for "xy" and found several hints that you might find useful. Good luck, LeAnne The Big Smelly Ogre wrote: Thanks for your help. I fully appreciate the time and effort that goes into helping others in these forums. That said, I played with this all weekend, and it seems that the best I can get access to do at producing an x-y plot is really more of a bar chart without the bars. All of the x data must fall on a given, evenly spaced line. My data's not so neat. I need to plot what are essentially coordinates on a map, something like this: point x y 1 16542.0 8546.4 2 17634.5 6385.4 3 15964.8 7642.3 This is very easy to do in Excel, and I have set it up to plot my data. But, it would be much more useful to do it from within Access. And, since both programs use the same graphing system, it should be possible. The question is, how? "LeAnne" wrote: Access wizards are often quite stupid. You'll find a workaround for the pointless requirement to sum or otherwise aggregate chart data at http://www.cpcug.org/user/clemenzi/t...ss/Charts.html hth, LeAnne The Big Smelly Ogre wrote: Here is the underlying query: SELECT Resource, Latitude, Longitude FROM qryDeposits ORDER BY Resource; Here is the query that the wizrd places into the chart's Row Source: SELECT [Resource],Sum([Latitude]) AS [SumOfLatitude] FROM [qryGraph] GROUP BY [Resource]; What I want is a simple plot of latitude vs. longitude, with a different symbol for each resource. I can export the query to an Excel spreadsheet and plot it, but I would prefer to do it within Access. Eventually I want to be able to add controls to enble the control of the plotted range and scale, but I need to get the basic graph to work first. "LeAnne" wrote: Please post the SQL for the query in the RowSource property for the chart. If there's an underlying query, post that SQL as well. LeAnne The Big Smelly Ogre wrote: How can I get a simple x-y plot? The wizard insists on grouping and summing the data, which is not what I need. A search of this forum didn't shed any light on the subject. |
#7
|
|||
|
|||
x-y plots
Okay, I'm getting a plot now. Thank you very much.
Now, I need to break the data down into series, with a different coordinate set for each series. Something like this: Rock Tree Flower x y x y x y 1 3 1 9 2 4 2 1 2 6 2 8 6 4 2 7 5 2 Any ideas? "LeAnne" wrote: BSO, It's certainly possible. Did you go to the link I posted? There are pretty straightforward instructions on how to create an xy scatterplot. As I said before, the Access ChartWizard is stupid. I would only rely on the Wizard to throw a chart (any old chart) on my Form quickly. Then I prefer to modify the RowSource query, change the chart type etc. manually. Some thoughts: Are you sure your coordinates are really NUMBERS? Lats and longs (or UTMs, or other spatial data) aren't "numbers" in the sense that you can do math with them. After all, 16542.0 + 8546.4 doesn't produce anything meaningful. Access and MS Graph require at least 1 field to be numeric. Second (as was pointed out in the link), it's easy to modify the underlying query manually. Just remove the Sum() or other aggregate function from the SQL statement. You'll need to also delete the GROUP BY clause or you'll get an error. Finally, I'd suggest building your form, adding your chart, double-click on the chart to launch MS Graph, and plunging right in with the MS Graph Help file (table of contents). There's (surprise!) quite a bit of helpful information. I also searched Graph Help for "xy" and found several hints that you might find useful. Good luck, LeAnne The Big Smelly Ogre wrote: Thanks for your help. I fully appreciate the time and effort that goes into helping others in these forums. That said, I played with this all weekend, and it seems that the best I can get access to do at producing an x-y plot is really more of a bar chart without the bars. All of the x data must fall on a given, evenly spaced line. My data's not so neat. I need to plot what are essentially coordinates on a map, something like this: point x y 1 16542.0 8546.4 2 17634.5 6385.4 3 15964.8 7642.3 This is very easy to do in Excel, and I have set it up to plot my data. But, it would be much more useful to do it from within Access. And, since both programs use the same graphing system, it should be possible. The question is, how? "LeAnne" wrote: Access wizards are often quite stupid. You'll find a workaround for the pointless requirement to sum or otherwise aggregate chart data at http://www.cpcug.org/user/clemenzi/t...ss/Charts.html hth, LeAnne The Big Smelly Ogre wrote: Here is the underlying query: SELECT Resource, Latitude, Longitude FROM qryDeposits ORDER BY Resource; Here is the query that the wizrd places into the chart's Row Source: SELECT [Resource],Sum([Latitude]) AS [SumOfLatitude] FROM [qryGraph] GROUP BY [Resource]; What I want is a simple plot of latitude vs. longitude, with a different symbol for each resource. I can export the query to an Excel spreadsheet and plot it, but I would prefer to do it within Access. Eventually I want to be able to add controls to enble the control of the plotted range and scale, but I need to get the basic graph to work first. "LeAnne" wrote: Please post the SQL for the query in the RowSource property for the chart. If there's an underlying query, post that SQL as well. LeAnne The Big Smelly Ogre wrote: How can I get a simple x-y plot? The wizard insists on grouping and summing the data, which is not what I need. A search of this forum didn't shed any light on the subject. |
#8
|
|||
|
|||
x-y plots
Hmm...nope, sorry. I mean, I can tell you how to do it in Excel, but MS
Graph via Access doesn't seem to allow that option directly; at least, none that I can find. HOWEVER, it is possible to create such a graph in Excel (plot the rock, tree, and flower as separate series, using a different marker for each series) and then import that Excel chart directly to your form via MS Graph. Create form, insert chart object (doesn't matter what kind, or what source), double-click chart to open MS Graph, go to the datasheet, click the Import File button, and browse until you find the Excel worksheet containing the graph you want. Import it, and MS Graph will bring in the chart AND the underlying data sources, correctly arranged, to Access. Good luck, LeAnne The Big Smelly Ogre wrote: Okay, I'm getting a plot now. Thank you very much. Now, I need to break the data down into series, with a different coordinate set for each series. Something like this: Rock Tree Flower x y x y x y 1 3 1 9 2 4 2 1 2 6 2 8 6 4 2 7 5 2 Any ideas? "LeAnne" wrote: BSO, It's certainly possible. Did you go to the link I posted? There are pretty straightforward instructions on how to create an xy scatterplot. As I said before, the Access ChartWizard is stupid. I would only rely on the Wizard to throw a chart (any old chart) on my Form quickly. Then I prefer to modify the RowSource query, change the chart type etc. manually. Some thoughts: Are you sure your coordinates are really NUMBERS? Lats and longs (or UTMs, or other spatial data) aren't "numbers" in the sense that you can do math with them. After all, 16542.0 + 8546.4 doesn't produce anything meaningful. Access and MS Graph require at least 1 field to be numeric. Second (as was pointed out in the link), it's easy to modify the underlying query manually. Just remove the Sum() or other aggregate function from the SQL statement. You'll need to also delete the GROUP BY clause or you'll get an error. Finally, I'd suggest building your form, adding your chart, double-click on the chart to launch MS Graph, and plunging right in with the MS Graph Help file (table of contents). There's (surprise!) quite a bit of helpful information. I also searched Graph Help for "xy" and found several hints that you might find useful. Good luck, LeAnne The Big Smelly Ogre wrote: Thanks for your help. I fully appreciate the time and effort that goes into helping others in these forums. That said, I played with this all weekend, and it seems that the best I can get access to do at producing an x-y plot is really more of a bar chart without the bars. All of the x data must fall on a given, evenly spaced line. My data's not so neat. I need to plot what are essentially coordinates on a map, something like this: point x y 1 16542.0 8546.4 2 17634.5 6385.4 3 15964.8 7642.3 This is very easy to do in Excel, and I have set it up to plot my data. But, it would be much more useful to do it from within Access. And, since both programs use the same graphing system, it should be possible. The question is, how? "LeAnne" wrote: Access wizards are often quite stupid. You'll find a workaround for the pointless requirement to sum or otherwise aggregate chart data at http://www.cpcug.org/user/clemenzi/t...ss/Charts.html hth, LeAnne The Big Smelly Ogre wrote: Here is the underlying query: SELECT Resource, Latitude, Longitude FROM qryDeposits ORDER BY Resource; Here is the query that the wizrd places into the chart's Row Source: SELECT [Resource],Sum([Latitude]) AS [SumOfLatitude] FROM [qryGraph] GROUP BY [Resource]; What I want is a simple plot of latitude vs. longitude, with a different symbol for each resource. I can export the query to an Excel spreadsheet and plot it, but I would prefer to do it within Access. Eventually I want to be able to add controls to enble the control of the plotted range and scale, but I need to get the basic graph to work first. "LeAnne" wrote: Please post the SQL for the query in the RowSource property for the chart. If there's an underlying query, post that SQL as well. LeAnne The Big Smelly Ogre wrote: How can I get a simple x-y plot? The wizard insists on grouping and summing the data, which is not what I need. A search of this forum didn't shed any light on the subject. |
#9
|
|||
|
|||
x-y plots
Thanks again for your help. I already have Excel set up to plot my data. I
was just hoping to make things cleaner by putting it all into one application. "LeAnne" wrote: Hmm...nope, sorry. I mean, I can tell you how to do it in Excel, but MS Graph via Access doesn't seem to allow that option directly; at least, none that I can find. HOWEVER, it is possible to create such a graph in Excel (plot the rock, tree, and flower as separate series, using a different marker for each series) and then import that Excel chart directly to your form via MS Graph. Create form, insert chart object (doesn't matter what kind, or what source), double-click chart to open MS Graph, go to the datasheet, click the Import File button, and browse until you find the Excel worksheet containing the graph you want. Import it, and MS Graph will bring in the chart AND the underlying data sources, correctly arranged, to Access. Good luck, LeAnne The Big Smelly Ogre wrote: Okay, I'm getting a plot now. Thank you very much. Now, I need to break the data down into series, with a different coordinate set for each series. Something like this: Rock Tree Flower x y x y x y 1 3 1 9 2 4 2 1 2 6 2 8 6 4 2 7 5 2 Any ideas? "LeAnne" wrote: BSO, It's certainly possible. Did you go to the link I posted? There are pretty straightforward instructions on how to create an xy scatterplot. As I said before, the Access ChartWizard is stupid. I would only rely on the Wizard to throw a chart (any old chart) on my Form quickly. Then I prefer to modify the RowSource query, change the chart type etc. manually. Some thoughts: Are you sure your coordinates are really NUMBERS? Lats and longs (or UTMs, or other spatial data) aren't "numbers" in the sense that you can do math with them. After all, 16542.0 + 8546.4 doesn't produce anything meaningful. Access and MS Graph require at least 1 field to be numeric. Second (as was pointed out in the link), it's easy to modify the underlying query manually. Just remove the Sum() or other aggregate function from the SQL statement. You'll need to also delete the GROUP BY clause or you'll get an error. Finally, I'd suggest building your form, adding your chart, double-click on the chart to launch MS Graph, and plunging right in with the MS Graph Help file (table of contents). There's (surprise!) quite a bit of helpful information. I also searched Graph Help for "xy" and found several hints that you might find useful. Good luck, LeAnne The Big Smelly Ogre wrote: Thanks for your help. I fully appreciate the time and effort that goes into helping others in these forums. That said, I played with this all weekend, and it seems that the best I can get access to do at producing an x-y plot is really more of a bar chart without the bars. All of the x data must fall on a given, evenly spaced line. My data's not so neat. I need to plot what are essentially coordinates on a map, something like this: point x y 1 16542.0 8546.4 2 17634.5 6385.4 3 15964.8 7642.3 This is very easy to do in Excel, and I have set it up to plot my data. But, it would be much more useful to do it from within Access. And, since both programs use the same graphing system, it should be possible. The question is, how? "LeAnne" wrote: Access wizards are often quite stupid. You'll find a workaround for the pointless requirement to sum or otherwise aggregate chart data at http://www.cpcug.org/user/clemenzi/t...ss/Charts.html hth, LeAnne The Big Smelly Ogre wrote: Here is the underlying query: SELECT Resource, Latitude, Longitude FROM qryDeposits ORDER BY Resource; Here is the query that the wizrd places into the chart's Row Source: SELECT [Resource],Sum([Latitude]) AS [SumOfLatitude] FROM [qryGraph] GROUP BY [Resource]; What I want is a simple plot of latitude vs. longitude, with a different symbol for each resource. I can export the query to an Excel spreadsheet and plot it, but I would prefer to do it within Access. Eventually I want to be able to add controls to enble the control of the plotted range and scale, but I need to get the basic graph to work first. "LeAnne" wrote: Please post the SQL for the query in the RowSource property for the chart. If there's an underlying query, post that SQL as well. LeAnne The Big Smelly Ogre wrote: How can I get a simple x-y plot? The wizard insists on grouping and summing the data, which is not what I need. A search of this forum didn't shed any light on the subject. |
#10
|
|||
|
|||
x-y plots
You're welcome!
L. The Big Smelly Ogre wrote: Thanks again for your help. I already have Excel set up to plot my data. I was just hoping to make things cleaner by putting it all into one application. "LeAnne" wrote: Hmm...nope, sorry. I mean, I can tell you how to do it in Excel, but MS Graph via Access doesn't seem to allow that option directly; at least, none that I can find. HOWEVER, it is possible to create such a graph in Excel (plot the rock, tree, and flower as separate series, using a different marker for each series) and then import that Excel chart directly to your form via MS Graph. Create form, insert chart object (doesn't matter what kind, or what source), double-click chart to open MS Graph, go to the datasheet, click the Import File button, and browse until you find the Excel worksheet containing the graph you want. Import it, and MS Graph will bring in the chart AND the underlying data sources, correctly arranged, to Access. Good luck, LeAnne The Big Smelly Ogre wrote: Okay, I'm getting a plot now. Thank you very much. Now, I need to break the data down into series, with a different coordinate set for each series. Something like this: Rock Tree Flower x y x y x y 1 3 1 9 2 4 2 1 2 6 2 8 6 4 2 7 5 2 Any ideas? "LeAnne" wrote: BSO, It's certainly possible. Did you go to the link I posted? There are pretty straightforward instructions on how to create an xy scatterplot. As I said before, the Access ChartWizard is stupid. I would only rely on the Wizard to throw a chart (any old chart) on my Form quickly. Then I prefer to modify the RowSource query, change the chart type etc. manually. Some thoughts: Are you sure your coordinates are really NUMBERS? Lats and longs (or UTMs, or other spatial data) aren't "numbers" in the sense that you can do math with them. After all, 16542.0 + 8546.4 doesn't produce anything meaningful. Access and MS Graph require at least 1 field to be numeric. Second (as was pointed out in the link), it's easy to modify the underlying query manually. Just remove the Sum() or other aggregate function from the SQL statement. You'll need to also delete the GROUP BY clause or you'll get an error. Finally, I'd suggest building your form, adding your chart, double-click on the chart to launch MS Graph, and plunging right in with the MS Graph Help file (table of contents). There's (surprise!) quite a bit of helpful information. I also searched Graph Help for "xy" and found several hints that you might find useful. Good luck, LeAnne The Big Smelly Ogre wrote: Thanks for your help. I fully appreciate the time and effort that goes into helping others in these forums. That said, I played with this all weekend, and it seems that the best I can get access to do at producing an x-y plot is really more of a bar chart without the bars. All of the x data must fall on a given, evenly spaced line. My data's not so neat. I need to plot what are essentially coordinates on a map, something like this: point x y 1 16542.0 8546.4 2 17634.5 6385.4 3 15964.8 7642.3 This is very easy to do in Excel, and I have set it up to plot my data. But, it would be much more useful to do it from within Access. And, since both programs use the same graphing system, it should be possible. The question is, how? "LeAnne" wrote: Access wizards are often quite stupid. You'll find a workaround for the pointless requirement to sum or otherwise aggregate chart data at http://www.cpcug.org/user/clemenzi/t...ss/Charts.html hth, LeAnne The Big Smelly Ogre wrote: Here is the underlying query: SELECT Resource, Latitude, Longitude FROM qryDeposits ORDER BY Resource; Here is the query that the wizrd places into the chart's Row Source: SELECT [Resource],Sum([Latitude]) AS [SumOfLatitude] FROM [qryGraph] GROUP BY [Resource]; What I want is a simple plot of latitude vs. longitude, with a different symbol for each resource. I can export the query to an Excel spreadsheet and plot it, but I would prefer to do it within Access. Eventually I want to be able to add controls to enble the control of the plotted range and scale, but I need to get the basic graph to work first. "LeAnne" wrote: Please post the SQL for the query in the RowSource property for the chart. If there's an underlying query, post that SQL as well. LeAnne The Big Smelly Ogre wrote: How can I get a simple x-y plot? The wizard insists on grouping and summing the data, which is not what I need. A search of this forum didn't shed any light on the subject. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel gives me line plots - I want scatter plots | Pangloss | Charts and Charting | 1 | October 14th, 2005 02:15 PM |
overlaying xy plots on same axis | windsurferLA | Charts and Charting | 3 | May 4th, 2005 12:51 PM |
scaling plots lengths | Chris | Charts and Charting | 0 | January 15th, 2005 11:35 AM |
resizing plots without changing text size | Martin Glodde | Charts and Charting | 4 | December 8th, 2003 01:35 PM |
Help ! Scatter Chart plots wrongly ! | Jon Peltier | Charts and Charting | 2 | November 19th, 2003 12:57 PM |