View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Greg G[_2_] Greg G[_2_] is offline
external usenet poster
 
Posts: 2
Default Stacked chart with data gaps


Here it is in a nutshell. I've got a bunch of data points like this:

Label Center Width Lower Upper
2 55.25 6 54 60
3 61.25 6 60 66
4 67.25 6 66 72
5 77.25 6 76 82
6 83.25 6 82 88
7 99 6 96 102
8 105 6 102 108

and I want to make a stacked bar chart to show the values between the
upper and lower as colored in, but still skip the empty ranges (like
between 88 and 96).

I'm just not having any luck doing this. Any suggestions?

Thanks.

-Greg G