Format Horizontal Axis on Chart so Values Repeat

[Prevost]

Hi There,

I am trying to make a horizontally stacked bar chart to track some progress. I would like to have a percentage value on the x axis, but have it repeat itself once it reaches 100 (to track between 0% and 100% for each task). The vertical axis will contain the main tasks. The series will be the sub tasks (which are common to each of the main tasks but will differ in percent completion from one main task to another) to track them. I have two questions,

1. Can I format the horizontal axis so the values repeat themselves?

2. Can I have the series not connected to one another, so for a main task, the first sub task could be 50% done while the next sub task could be 100% done and the first sub task would not be connected to the second sub task (but the second sub task would be connected to the third because it is 100% complete).

I have pasted a picture of a chart as it is formatted now (which is incorrect) that hopefully helps. If there is anything else required please let me know! I appreciate any help or advice!

Thanks,


-- removed inline image ---