Thanks Andy. Good trick !

In fact, I used the max-min values and selected min and that 3rd series to
get real numbers on the axis. But label values should be edited manually to
enter correct max values.

This is a pretty standard graph, I can't imagine that the guys at MS didn't
saw that coming.



"Andy Pope" a écrit dans le message de
...
Hi,

In order to get the Max point of the bar in the correct place you will
need to re calculate the max values used. So in another column plot the
formula which would be MaxValue - MinValue.

Or use a clustered bar chart. Format the Min series to have no border and
a fill colour that matches the plot area fill colour.
Set the Overlap value to 100.
reverse the plot order so Min is plotted on top of Max.

The only draw back with the overlap approach is the obscuring of
gridlines.

Cheers
Andy


Junkyard Engineer wrote:
I have a list of 24 set of data. Each category have a min-max set in $.

When I'm using stacked bar chart and define the min value with no fill, I
get the look I'm looking for. The problem is with the X-axis which shows
the total amount of min+max instead of using only the max series as data
set.

After looking around for quite a good time, I figured somebody here might
have stumbled on that problem.

Thanks