I'm trying to create a "floating bar" chart that has the "# of Techs" as my
catagory axis, months as my value axis. The chart displays the # of techs
required to perform the job in each month (1 year). However, my months are
all 31 days in my chart so my data gets a little skewed as the year goes by.

I have created a formula to correct this, BUT only if the information in my
"start date" column are consecutive, which they may not always be.

My series data consists of the "start date" as series 1 and "# of days to
complete" as series 2.

Any way to "fool" the chart?


-- I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!