I have values that ranges from 0 to 9 for time series data from 2001 to 2010. I want to highlight points which are less than 2 and higher than 4 with colors for selected Class (e.g. A or B or all ) on a time series line graph.
Is there a way we can do that?
Here are my example data:
Class2001200220032004200520062007200820092010A1352479236B4121366782C9143114972D7455245678E2967843128F5771376144G2282162288
Message was edited by: Astrick Cram
very complex but can't help you without seeing your workbook
your first post implies that you have a measure that can vary with 2 different dimensions
and you want to identify when that measure can have 2 different values at the same time
your second post indicates that you have a number of years as individual measures - that is very different than your first post
typically we would advise you to pivot the data around the Class dimension
go to the Data source tab and highlight all of the year measures the go to a header and right click it and select Pivot
you will have 2 columns - one is Pivot Measures the other is Pivot Values - rename the first as years
I would also make it into a date Using Makedate or Dateparse
Then you have something that you can plot
Jim
