| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| Creating a High-Low-Close chart with multiple series? | Charts and Charting in Excel | |||
| Can I use data from different worksheets to create a chart | Charts and Charting in Excel | |||
| automatically expand chart data series as data is added | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
