I a using Excel 2000 at work and am graphing historical data. The data was recorded every month for the past 12+ years. Looks like
"area 1" "month 1" "month 2" .... "month x"
"area 2" "month 1" "month 2" .... "month x"
"area ..." "month 1" "month 2" .... "month x"
"area x" "month 1" "month 2" .... "month x"
There are random months in each year that the collected data was either invalid or guessed so its cell is highlighed yellow. Is there a way that I can graph the all of the data and "invalid" data, the actual data marker on the graph, would be a different color or marker type?
Bookmarks