Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Pivot Multiple Graph And Trend Line

  1. #1
    Join Date
    6th November 2006
    Posts
    109

    Pivot Multiple Graph And Trend Line

    Hi,

    I got a pivot table with following details
    Row Values: Dept_Code, Super_group, Product_Group
    Column Values: Ending_Date
    Data: Sales, Availability%, Waste%, Number of Stores

    i need to have a bar chart with trend line individually on each data items e.g.Sales, Availability% etc.
    when i tried to use trend line it prompts me to enter series i.e Ending_Date and it draws trend line for only that period comparing all data values.

    is there any way to have individual graph for Sales, Availability%, Waste%, Number of Stores with trend line covering

    Any help will be much appreciated

    Thanx:

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    6th November 2006
    Posts
    109

    Re: Pivot Multiple Graph And Trend Line

    Hi,

    ?? Not a single reply


    if there are multiple data items on a pivot table, is it possible to have a individual graph for each item.?

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Pivot Multiple Graph And Trend Line

    I doubt you can have multiple pivot charts based on a single pivot table as the changes in the chart are automatically reflected in the table.

    You would need multiple tables in order to have multiple charts.
    Or create normal charts instead of pivot charts.

    Cheers
    Andy


  4. #4
    Join Date
    6th November 2006
    Posts
    109

    Re: Pivot Multiple Graph And Trend Line

    Thanx Andy Pope,

    I just manage it by invoking the macro to copy the data to a new sheet and then have all the charts.

    Thanx alot

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 0
    Last Post: April 17th, 2009, 23:04
  2. Coefficients Of Trend Line Equation
    By cichaaacz in forum EXCEL HELP
    Replies: 1
    Last Post: December 17th, 2007, 23:13
  3. Add Line To Chart To See Trend
    By burgo100 in forum EXCEL HELP
    Replies: 4
    Last Post: December 13th, 2007, 11:27
  4. Stock Chart With Trend Line
    By mikezang in forum EXCEL HELP
    Replies: 7
    Last Post: February 14th, 2007, 10:53
  5. Add Trend Line To Chart
    By countryfan_nt in forum EXCEL HELP
    Replies: 1
    Last Post: December 17th, 2006, 13:25

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
  •  
porno