+ Reply to Thread
Results 1 to 2 of 2

Trendline in Barchart

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Trendline in Barchart

    Hi,have 3 name in my column and 4 period in my Row, I wan to have a treadline within each name. Is it possible?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Trendline in Barchart

    Short but useless answer -- yes, it is possible to add a trendline to a 2D clustered bar chart. According to the help file linked below, stacked bar charts do not accept trendlines, so it might depend on exactly what kind of bar chart you have. I would expect:
    1) Data arranged in spreadsheet so that you can easily create a clustered bar chart with multiple data series (I assume you can already do this).
    2) Create bar chart.
    3) Add trendline to the desired data series: https://support.office.com/en-us/art...rs=en-US&ad=US
    4) Other formatting as desired.

    What step are you having trouble with?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Changing from GOOGLE API to BarChart API
    By Mustang65 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2018, 08:22 PM
  2. Sorting in barchart
    By gromtouwe in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2017, 04:28 AM
  3. Help me filter in barchart?
    By horsefish01 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-11-2016, 04:42 AM
  4. [SOLVED] Excel 2010 Trendline With Data labels or number on forward forecast trendline
    By camelight in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-15-2015, 08:35 AM
  5. Highlight each bar in a barchart in order using VBA
    By cpadude in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-24-2011, 09:37 AM
  6. Fill of bars in barchart
    By lraeburn in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-22-2011, 03:53 AM
  7. How do I show % of Goal within a single bar, on barchart
    By Army Guy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-25-2006, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1