If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Select data for plot
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 |
#2
|
|||
|
|||
Select data for plot
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 news 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 |
Thread Tools | |
Display Modes | |
|
|