Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Trendline on stacked bar graph
Hello How can you add a trendline to a stacked bar graph? Thanks -- Joni ------------------------------------------------------------------------ Joni's Profile: http://www.excelforum.com/member.php...o&userid=13596 View this thread: http://www.excelforum.com/showthread...hreadid=513635 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Trendline on stacked bar graph
Keep in mind that a stacked chart depicts a sum of one or more series, not
just each series. Trendlines only work on individual series. You could either generate trendlines for each series on a non-stacked basis, or you could add dummy line chart series to the stacked column chart that use summed data (use worksheet formulas to generate the data), and generate trendlines on these added series. Keep in mind also that category values are not necessarily the best correlating variable to use in a trendline regression. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Joni" wrote in message ... Hello How can you add a trendline to a stacked bar graph? Thanks -- Joni |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display two seperate stacked bars in a graph | Charts and Charting in Excel | |||
How do you combine a stacked column and single column graph? | Charts and Charting in Excel | |||
How do I set up a clustered stacked column graph? Is it possible? | Charts and Charting in Excel | |||
How do I show negative numbers on a stacked graph | Charts and Charting in Excel | |||
Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel |