Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked bar graphs
Is it possible to add add trend lines to stacked bar graphs?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked bar graphs
A trendline will not take into account the addition of previous series to
the one being fitted with the line. What I would do is add a trendline to the series, keep the textbox with the formula, but make the line less visible (you can't hide it completely, but you can at least use the background color as the line color). Then I would add a line series to the chart using the sum of values, so that the markers are planted on the top of the stacked columns. I would hide this line (no markers, no line), and fit a trendline to this series. I would not display the formula for this line, I'd drag the other formula up to this line. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Dixie" wrote in message ... Is it possible to add add trend lines to stacked bar graphs? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
Copying Charts and graphs to another worksheet with formulas | Excel Worksheet Functions | |||
How do I create two stacked column graphs together? | Excel Discussion (Misc queries) | |||
How to make a stacked bar chart using time? | Charts and Charting in Excel | |||
Stacked bar graphs | Charts and Charting in Excel |