Hello!
I want to see on the chart weeks filled with hours.
Attached example:
See weeks: 1, 2, 3, 10, 12, 15, 19, 20, 21....
Chart_example.xlsx
Hello!
I want to see on the chart weeks filled with hours.
Attached example:
See weeks: 1, 2, 3, 10, 12, 15, 19, 20, 21....
Chart_example.xlsx
Last edited by cascao; 06-20-2012 at 10:54 PM.
sorry, im not understanding what you are trying to achieve? ould you explain in a bit more detail please?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I want to see on the chart weeks filled with hours.
Attached example:
Weeks: 1, 2, 3, 10, 12, 15, 19, 20, 21....
does this one work?
Ben Van Johnson
@ cascao ... i am not getting what exactly u need .. can u please explain a bit
SANDEEP
<< press the star * if u like
Your current named range approach only determines the number of items to use but starts selecting that number from the top of the list. Which means the zero values as still included.
You need to create an alternative set of data with the zero values removed.
Thank you all.
The answer is what Andy said.
Andy, one more question:
If the previous week, the hours are greater than 0. The next week, even if hours = 0, will appears in the chart..
Example:
WEEK 9 - 22:00:00 - show
WEEK 10 - 0:00:00 - show
WEEK 11 - 0:00:00 - hide
WEEK 12 - 12:00:00 - show
WEEK 13 - 18:00:00 - show
...
Got it. I added OFFSET:
=SMALL(IF($C$2:$C$22>0;$A$2:$A$22;IF(OFFSET($C$2:$C$22;-1;0)>0;$A$2:$A$22;ROWS($A$1:$A$22)));ROW($A$1:$A$21))
Last edited by cascao; 06-21-2012 at 02:36 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks