Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked column chart not baselining at 0
I have a data set with categories in columns A-B, and data in columns C-I.
I've configured my chart to use stacked bars for the first 6 data series and a line for the last one. The first 6 are revenue allocations, with the 7th being a cumulative total. Most of the chart looks as expected, but the first category or row of data is displaying oddly. The figures in this row are all negative (or 0), so I expect the top of the bar to sit at zero, but it doesn't. The top of the bar sits at the value of the 7th/line series, so that the bottom of the bar is at 2x that (negative) value. Anyone have any tips on how to fix |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked column chart not baselining at 0
I can't reproduce this problem, in 2003 or 2007. The first category stacks
downward from the horizontal axis to the point on the line series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LovePS" wrote in message ... I have a data set with categories in columns A-B, and data in columns C-I. I've configured my chart to use stacked bars for the first 6 data series and a line for the last one. The first 6 are revenue allocations, with the 7th being a cumulative total. Most of the chart looks as expected, but the first category or row of data is displaying oddly. The figures in this row are all negative (or 0), so I expect the top of the bar to sit at zero, but it doesn't. The top of the bar sits at the value of the 7th/line series, so that the bottom of the bar is at 2x that (negative) value. Anyone have any tips on how to fix |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked column chart not baselining at 0
Can I send an example?
"Jon Peltier" wrote: I can't reproduce this problem, in 2003 or 2007. The first category stacks downward from the horizontal axis to the point on the line series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LovePS" wrote in message ... I have a data set with categories in columns A-B, and data in columns C-I. I've configured my chart to use stacked bars for the first 6 data series and a line for the last one. The first 6 are revenue allocations, with the 7th being a cumulative total. Most of the chart looks as expected, but the first category or row of data is displaying oddly. The figures in this row are all negative (or 0), so I expect the top of the bar to sit at zero, but it doesn't. The top of the bar sits at the value of the 7th/line series, so that the bottom of the bar is at 2x that (negative) value. Anyone have any tips on how to fix |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked column chart not baselining at 0
Hmmm, well okay.
jonxlmvp at peltiertech dot com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LovePS" wrote in message ... Can I send an example? "Jon Peltier" wrote: I can't reproduce this problem, in 2003 or 2007. The first category stacks downward from the horizontal axis to the point on the line series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LovePS" wrote in message ... I have a data set with categories in columns A-B, and data in columns C-I. I've configured my chart to use stacked bars for the first 6 data series and a line for the last one. The first 6 are revenue allocations, with the 7th being a cumulative total. Most of the chart looks as expected, but the first category or row of data is displaying oddly. The figures in this row are all negative (or 0), so I expect the top of the bar to sit at zero, but it doesn't. The top of the bar sits at the value of the 7th/line series, so that the bottom of the bar is at 2x that (negative) value. Anyone have any tips on how to fix |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked column chart not baselining at 0
I rebooted, and now I can't reproduce it either. Whatever the cause, it is
fixed now, so I'm happy. I find that a reboot fixes most Excel bugs, but this time it took 3 reboots. Stacey "Jon Peltier" wrote: Hmmm, well okay. jonxlmvp at peltiertech dot com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LovePS" wrote in message ... Can I send an example? "Jon Peltier" wrote: I can't reproduce this problem, in 2003 or 2007. The first category stacks downward from the horizontal axis to the point on the line series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LovePS" wrote in message ... I have a data set with categories in columns A-B, and data in columns C-I. I've configured my chart to use stacked bars for the first 6 data series and a line for the last one. The first 6 are revenue allocations, with the 7th being a cumulative total. Most of the chart looks as expected, but the first category or row of data is displaying oddly. The figures in this row are all negative (or 0), so I expect the top of the bar to sit at zero, but it doesn't. The top of the bar sits at the value of the 7th/line series, so that the bottom of the bar is at 2x that (negative) value. Anyone have any tips on how to fix |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked column chart not baselining at 0
Next time after exiting Excel, clean out the temp directory before
restarting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LovePS" wrote in message ... I rebooted, and now I can't reproduce it either. Whatever the cause, it is fixed now, so I'm happy. I find that a reboot fixes most Excel bugs, but this time it took 3 reboots. Stacey "Jon Peltier" wrote: Hmmm, well okay. jonxlmvp at peltiertech dot com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LovePS" wrote in message ... Can I send an example? "Jon Peltier" wrote: I can't reproduce this problem, in 2003 or 2007. The first category stacks downward from the horizontal axis to the point on the line series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LovePS" wrote in message ... I have a data set with categories in columns A-B, and data in columns C-I. I've configured my chart to use stacked bars for the first 6 data series and a line for the last one. The first 6 are revenue allocations, with the 7th being a cumulative total. Most of the chart looks as expected, but the first category or row of data is displaying oddly. The figures in this row are all negative (or 0), so I expect the top of the bar to sit at zero, but it doesn't. The top of the bar sits at the value of the 7th/line series, so that the bottom of the bar is at 2x that (negative) value. Anyone have any tips on how to fix |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked column chart not baselining at 0
This was caused by a second Y-axis. the series was aligning to the 0-value on
the second axis instead of the first. "Jon Peltier" wrote: I can't reproduce this problem, in 2003 or 2007. The first category stacks downward from the horizontal axis to the point on the line series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LovePS" wrote in message ... I have a data set with categories in columns A-B, and data in columns C-I. I've configured my chart to use stacked bars for the first 6 data series and a line for the last one. The first 6 are revenue allocations, with the 7th being a cumulative total. Most of the chart looks as expected, but the first category or row of data is displaying oddly. The figures in this row are all negative (or 0), so I expect the top of the bar to sit at zero, but it doesn't. The top of the bar sits at the value of the 7th/line series, so that the bottom of the bar is at 2x that (negative) value. Anyone have any tips on how to fix |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked column chart wit more than one column in a data point | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
How to combine stacked column with a cluster column chart? | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |