Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2017, 08:37 PM
shimulsiddiquee shimulsiddiquee is offline I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable Windows 7 64bit I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable Office 2007
Novice
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable
 
Join Date: May 2017
Location: DHaka, Bangladesh
Posts: 1
shimulsiddiquee is on a distinguished road
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable
Default 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.
Reply With Quote
  #2  
Old 05-16-2017, 07:39 AM
gebobs gebobs is offline I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable Windows 7 64bit I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable Run-time error 91 object variable or with block variable not set JUST ME Word VBA 4 03-25-2014 06:56 AM
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable object variable or with block variable not set MJP143 Excel 1 02-11-2013 05:07 AM
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable Run-time error '91': Object variable or With block variable not set tinfanide Excel Programming 2 06-10-2012 10:17 AM
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable How to create a chart with a variable width column? Guy Roth Excel 1 03-20-2012 05:52 AM


All times are GMT -7. The time now is 01:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft