hmltnangel
Active Member
- Joined
- Aug 25, 2010
- Messages
- 290
- Office Version
- 365
- Platform
- Windows
Morning ALl,
I have a dynamic chart that I created and used the following formulas to work out the "values" and "groups"
Groups =$B$4:INDEX($B$4:$B$10,COUNT($C$4:$C$10))
Values =$C$4:INDEX($C$4:$C$10,COUNT($C$4:$C$10))
It seemed to be working ok, and I have teh chart using the named ranges. But It now has decided to select the first 4 rows of data, even where there is a blank. ANy suggestions?
I have a dynamic chart that I created and used the following formulas to work out the "values" and "groups"
Groups =$B$4:INDEX($B$4:$B$10,COUNT($C$4:$C$10))
Values =$C$4:INDEX($C$4:$C$10,COUNT($C$4:$C$10))
It seemed to be working ok, and I have teh chart using the named ranges. But It now has decided to select the first 4 rows of data, even where there is a blank. ANy suggestions?