Graphing in Excel

[Mark McInerney]

Hi All,

I have data in 1 columns - 2 years worth of data. I want to colour code the graph of the data across each of the 4 quarters of the year - 1 thru 4.

I am using a formula with "month" in it and "if then else", and creating 4 new columns e.g. Column 1 populates if the number of the month is 1, 2 or 3 - if it does not equal any of these it populates with #n/a. The problem starts when the next series of numbers hits, and it joins lines from the last valid number to the next valid number, even when there are #n/a in the cells?

Any Help - Appreciated.

It works fine, until I get to the second

[/URL][/IMG]

 

[mole999]

model the data on seperate rows then plot that, look up Peltier Tech Blog - Peltier Tech Excel Charts and Programming Blog

 

[Mark McInerney]

Hi Mole,

Thanks for coming back to me - appreciated - will check out the link - Thanks again.