Varying data in plot

  • Thread starter Thread starter elbows
  • Start date Start date
E

elbows

Hi. I'm have trouble plotting the correct data and tying it to the
correct date.

x y z
9/1 y y n
9/2 y y y
9/3 n y y
9/4 n y y

Y's and N's represent numbers, but say that if it is a y, that means
that I want it on the plot and if it is an n, I want nothing there.

The problem I'm having is that when I select the data I want to plot,
it does not correspond to the correct date on the x-axis of the plot at
all. Everything gets pushed to the earliest dates.

I could take out data that are represented by n but would prefer not
to, as this changes frequently.

Thanks for any help!
 
If the data is in the chart data range, it's going into the chart.

You can use more than just these few columns if you want to control which data
appears in the chart. Leave dates in column A and the original data in B through D.
In columns E through G, put the actual letters Y and N. In cell H2 (assuming row 1
is reserved for series name labels), put this formula:

=IF(E2="Y",B2,NA())

Fill the rest of H:J with this formula, then plot the data in A and H:J. To select a
multiple area range, select the first area, then hold CTRL while selecting the next
area.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top