J
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
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