Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 273
- Office Version
- 365
- Platform
- Windows
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]
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
![ScreenHunter_3360%20Mar.%2021%2015.05_zpsrkocmlul.jpg](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22http%3A%2F%2Fs1053.photobucket.com%2Fuser%2FP0UGHREA%2Fmedia%2FScreenHunter_3360%2520Mar.%252021%252015.05_zpsrkocmlul.jpg.html%22%5D%5BIMG%5Dhttp%3A%2F%2Fi1053.photobucket.com%2Falbums%2Fs480%2FP0UGHREA%2FScreenHunter_3360%2520Mar.%252021%252015.05_zpsrkocmlul.jpg&hash=8e767822323cec6bbfcb081cbdfd4861)