How to dynamically populate series for an XY chart?

[Jason Weiss]

Hi,

Here's what I'm trying to do, and if you can help me get it to work, well,
I'll be thrilled...

I have a sheet in which users enter up to 48 tasks. Each task is
prioritized as 1, 2, or 3 (Column A), and has specific X-Y information
(Columns B and C) for plotting the task on an XY chart. I would like to
graph these as separate series such that all the 1's are one series, all the
2's are another, etc., so I can use separate markers to differentiate them.
The problem is that *any* given task can be a 1, 2, or 3, and there is no
limit or expectation around how many of each you can have--you could have no
1's, 48 1's, or anything in between, for example. Further, I'm trying to
avoid asking users to manually sort the sheet, enter the data in different
places depending on 1/2/3, or use a macro to sort them all out, if at all
possible.

So is there any way to dynamically generate a series and populate the XY
information based on this third set of values? I've looked everywhere I
can, and I can't seem to locate a way to do it.

My thanks to anyone who can help me with this doozy...

....Jay

 

[Jon Peltier]

Jason -

You haven't looked here:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

I show how to get what looks like a single series with different
markers. You can use the same approach, but leave off the line-only
series, and format the other series to use lines with the markers.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______