Floating bar chart, not showing last value correctly

[maggielady]

When creating a floating bar chart I have 2 series of dates. I can get the bar to start with the first date but it doesn't stop at the second date. I've tried formatting the axis but the bar continues to the edge of the chart?

 

[SkipVought]

Hi,

What is a "FLOATING" bar chart?

Please post your source data and describe which bar chart type you have selected.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[rollypac]

The chart is a custom chart called floating bar. It says you need two sets of data. The picture of the chart appears to start at the first set of data and stop at the second set.
When I use dates the bar starts at the first date but doesn't stop at the second date, it continues to the right edge of the chart.

 

[SkipVought]

That's because the FIRST set of data defines the START of each bar and the SECOND set of data defines the LENGTH of the bar and NOT the END.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884