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

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

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
>

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

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" <[email protected]> wrote in message
news:%[email protected]...
> 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

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" <[email protected]> wrote in message
> news:%[email protected]...
> > 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
>
>
>