|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable
Dear Forum Members,
Greetings. I am trying to create both bar chart and trendline in excel. I have a dataset of 6 variables of 5 different years. First I need to draw a bar chart. I have already done it. I facing a problem with the second one. I want to draw trendline for selected years of all variables. I have data of 2012, 2013, 2014, 2015 and 2016. I just want to draw trendline of 2014, 2015 and 2016. Is this possible? Thanks in advance. |
#2
|
|||
|
|||
You could do it manually, I suppose, though a three-point trend is not much of a trend at all. If you were to do it this way and assuming you don't need anything more complicated than a linear trendline, I would just use Insert Shape and draw a line through where you suppose the trend might be. More precision than that for a three-point trend is sort of silly.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge | Berryblue | Mail Merge | 1 | 11-13-2014 05:36 PM |
Run-time error 91 object variable or with block variable not set | JUST ME | Word VBA | 4 | 03-25-2014 06:56 AM |
object variable or with block variable not set | MJP143 | Excel | 1 | 02-11-2013 05:07 AM |
Run-time error '91': Object variable or With block variable not set | tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |
How to create a chart with a variable width column? | Guy Roth | Excel | 1 | 03-20-2012 05:52 AM |