Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked chart with data gaps
This should help you
http://www.peltiertech.com/Excel/Cha...kedCharts.html "Greg G" wrote: 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked chart with data gaps
Insert a series between 6 and 7 that covers the range from 88 to 96, and
hide it in the chart (double click, Patters tab, None for Border and Fill). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Greg G" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked chart with data gaps
Thanks. I was hoping to avoid that because these numbers will be changing, but I guess if I do that range to be hidden as a formula, it should work out OK. -Greg G Jon Peltier wrote: Insert a series between 6 and 7 that covers the range from 88 to 96, and hide it in the chart (double click, Patters tab, None for Border and Fill). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Greg G" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data series label in Stacked Chart | Charts and Charting in Excel | |||
How do I get total value data labels in a stacked bar chart? | Charts and Charting in Excel | |||
How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
Data labels on a stacked chart | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |