Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
Plot Hourly Data | Charts and Charting in Excel | |||
How do I plot two columns of data as one data point/marker in a ch | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
Can you show data in a data table but not plot it on the chart? | Charts and Charting in Excel |