Announcement

Collapse
No announcement yet.

Pivot Multiple Graph And Trend Line

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

  • #2
    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.?

    Comment


    • #3
      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

      Comment


      • #4


        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

        Comment

        Working...
        X