|
Create multiple data series for a chart in one shot...
Hi,
I'm trying to create a scatter chart and enter about 100 data series (a name, x value, y value for each). I could do it manually but I'm sure there's a more efficient way. Can you help? Thanks! Ron |
Create multiple data series for a chart in one shot...
Hi,
Do you really need the points to be separate series? Perhaps you can create a xy scatter on the x and y data and then use of these free addin to link your data labels to the names. Rob Bovey's Chart Labeler http://appspro.com Or John Walkenbach's Chart Tools http://j-walk.com Cheers Andy ronbrosh111 wrote: Hi, I'm trying to create a scatter chart and enter about 100 data series (a name, x value, y value for each). I could do it manually but I'm sure there's a more efficient way. Can you help? Thanks! Ron -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Create multiple data series for a chart in one shot...
Thanks for the response and advice.
I actually inherited a file (at work), where a large amount of series were entered in at once, and been asked to replicate the feat. Is there an organic way to do so in Excel, or are the add-ins the only option? Thanks again! Ron "Andy Pope" wrote: Hi, Do you really need the points to be separate series? Perhaps you can create a xy scatter on the x and y data and then use of these free addin to link your data labels to the names. Rob Bovey's Chart Labeler http://appspro.com Or John Walkenbach's Chart Tools http://j-walk.com Cheers Andy ronbrosh111 wrote: Hi, I'm trying to create a scatter chart and enter about 100 data series (a name, x value, y value for each). I could do it manually but I'm sure there's a more efficient way. Can you help? Thanks! Ron -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Create multiple data series for a chart in one shot...
Maybe you could write your own code to update and or create the chart.
What do you mean by 'organic way'? Cheers Andy ronbrosh111 wrote: Thanks for the response and advice. I actually inherited a file (at work), where a large amount of series were entered in at once, and been asked to replicate the feat. Is there an organic way to do so in Excel, or are the add-ins the only option? Thanks again! Ron "Andy Pope" wrote: Hi, Do you really need the points to be separate series? Perhaps you can create a xy scatter on the x and y data and then use of these free addin to link your data labels to the names. Rob Bovey's Chart Labeler http://appspro.com Or John Walkenbach's Chart Tools http://j-walk.com Cheers Andy ronbrosh111 wrote: Hi, I'm trying to create a scatter chart and enter about 100 data series (a name, x value, y value for each). I could do it manually but I'm sure there's a more efficient way. Can you help? Thanks! Ron -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Create multiple data series for a chart in one shot...
I think he means built in, as opposed to programmatic.
If you need programmatic techniques, this might be a good place to start: http://peltiertech.com/Excel/ChartsH...kChartVBA.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Andy Pope" wrote in message ... Maybe you could write your own code to update and or create the chart. What do you mean by 'organic way'? Cheers Andy ronbrosh111 wrote: Thanks for the response and advice. I actually inherited a file (at work), where a large amount of series were entered in at once, and been asked to replicate the feat. Is there an organic way to do so in Excel, or are the add-ins the only option? Thanks again! Ron "Andy Pope" wrote: Hi, Do you really need the points to be separate series? Perhaps you can create a xy scatter on the x and y data and then use of these free addin to link your data labels to the names. Rob Bovey's Chart Labeler http://appspro.com Or John Walkenbach's Chart Tools http://j-walk.com Cheers Andy ronbrosh111 wrote: Hi, I'm trying to create a scatter chart and enter about 100 data series (a name, x value, y value for each). I could do it manually but I'm sure there's a more efficient way. Can you help? Thanks! Ron -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Create multiple data series for a chart in one shot...
I ended up using the add-in you recommended. Turns out my predecessor
entered 100 data series in manually! Thanks for the help! Ron "Jon Peltier" wrote: I think he means built in, as opposed to programmatic. If you need programmatic techniques, this might be a good place to start: http://peltiertech.com/Excel/ChartsH...kChartVBA.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Andy Pope" wrote in message ... Maybe you could write your own code to update and or create the chart. What do you mean by 'organic way'? Cheers Andy ronbrosh111 wrote: Thanks for the response and advice. I actually inherited a file (at work), where a large amount of series were entered in at once, and been asked to replicate the feat. Is there an organic way to do so in Excel, or are the add-ins the only option? Thanks again! Ron "Andy Pope" wrote: Hi, Do you really need the points to be separate series? Perhaps you can create a xy scatter on the x and y data and then use of these free addin to link your data labels to the names. Rob Bovey's Chart Labeler http://appspro.com Or John Walkenbach's Chart Tools http://j-walk.com Cheers Andy ronbrosh111 wrote: Hi, I'm trying to create a scatter chart and enter about 100 data series (a name, x value, y value for each). I could do it manually but I'm sure there's a more efficient way. Can you help? Thanks! Ron -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| All times are GMT +1. The time now is 08:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com