Recent content by hzhm

Yes great. I think the answer to the next question is impossible due to the minute durations, but is it possible to change the x & Y values to show the start stop clearer? eg the gap between the major axis is too big. thanks

Hi I need to plot the following data to display start and end of each item - start on x - end on y Start Finish 0:01:02 0:01:18 0:12:01 0:13:00 0:22:28 0:23:02 0:33:01 0:34:02 0:44:04 0:44:25 0:54:28 0:55:26 1:07:23 1:08:08 1:18:22 1:19:20 1:29:01 1:29:25 How can I achieve this. See file...

SirJB7, I think I have the answer, the formula for the end range is a mixed reference not an absolute: instead of MATCH($E5,$H$4:$FM$4,1)) is would be MATCH($E5,$H$4:FM$4,1)). Correct?

thanks SirJB7, it works. Can the formula be modified so the column range is not limited to $FM$4. I want to auto update the range if more columns are added after FM. Normally I would add more columns to the end by a copy paste formatting and fill series for the dates. Otherwise I see the...

file uploaded again. thanks

Hi, I have a Gantt chart with conditional formatting (grey fill colour) that calculate on dates. One cell represents 1 week. See example sheet attached. The problem with my formula is that if I enter a date eg 30/9/2013 it fills the correct cell but also includes the previous week. Can someone...

See workbook link attached with above data and example scatter chart that requires data labels by country https://docs.google.com/file/d/0B24NeSS28mefM0xGMm1IVlZrWWc/edit?usp=sharing thanks Harald

Hi, I need help to create a scatter chart The data to plot is Receipts data (example below). Receipt data to appear on Y axis and Contributions on x axis. Then I need to display labels in plot area for Receipts by Country thanks Country - Contributions - Receipts Germany - 19.9 - 12.1...