conditionally adding series to graph

  • Thread starter Thread starter jg70124
  • Start date Start date
J

jg70124

Excel 2002

Is there any way to add a series to a graph if a particular cell has a
certain value?

I would want the Legend to be updated, as well.

Thanks in advance.
 
Hi
could be done using a dynamic range as data source. Would be helpful if
you can describe your spreadsheet design with a little bit more detail.
e.g. provide the following details
- some exampe rows of you data (plain text - no attachments please)
- what cell will trigger the chart
 
Sure.

Making a bubble chart, where each bubble represents a market segment. X
axis represents company's ability to satisfy segment requirements; Y axis is
segment attractiveness to the company; and size represents the amount of
revenues possible from the segment. In order for the legend to show the
names of the segments, each bubble has to be a separate series with one data
point.

The user will enter the number of segments to be tracked in a spreadsheet
cell near the data.

Thanks.
 
Back
Top