So far you have Proj1 through Proj4 Data. Add four more columns for Proj1
through Proj4 Chart. Assuming there is also a first column for some kind of
categories or dates, Proj1 Data is column D, Proj1 Chart is column F, row 2
has the Y/N.... then put this formula in F3:
=IF(B$2="Y",B3,NA())
fill this formula across to column I and down as far as there is data. Make
your chart with column A and F:I. Delete the legend from the chart, and
format the last point of each series to use the series name ("Proj1") as its
data label.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Saintsman" wrote in message
...
I want to create a simple line chart for each project; but need the ability
for the user to not plot a particular project (Y 0r N)
Proj1 Proj2 Proj3 Proj4
Y Y Y N
11.3% 8.5% 1.8% 0.9%
16.1% 12.4% 3.7% 1.5%
21.3% 16.6% 6.9% 3.9%
Any ideas?
Thanks
Saintsman