+ Reply to Thread
Results 1 to 2 of 2

Graph / Pivot Help!!

  1. #1
    Registered User
    Join Date
    09-24-2015
    Location
    London, England
    MS-Off Ver
    Office 2013
    Posts
    31

    Graph / Pivot Help!!

    Good Afternoon!

    I say my Excel knowledge is definitely intermediate however my graph knowledge is very, very basic

    I'm trying to generate some graphs for a monthly report showing forecasted figures against actual.
    Rather than having a graph a month, I was hoping to add a sheet in with some INDEX MATCH formulas which would return different data depending on what month was selected on the 'dashboard'.

    This works except I want the graph to always have the highest biller at the top;
    Capture.JPG

    I'd combated this by using pivot charts to drive the graphs however this meant having a graph for each month and this isn't particularly dynamic . . .

    Is there anyway around this? Any advice would be hugely appreciated
    Many thanks,
    Laura

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Graph / Pivot Help!!

    It would seem as if you could put your months into either the Report Filter or a slicer.
    It would be easier to help if you would upload a sample of the workbook from which the screenshot of the graph in post #1 is taken. To upload a workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Note: the paperclip icon does not work.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 1
    Last Post: 07-29-2016, 04:30 PM
  2. Pivot from a Pie Graph
    By Jpeterson in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-23-2014, 10:36 AM
  3. Replies: 2
    Last Post: 08-29-2011, 12:29 PM
  4. time graph pivot
    By afgi in forum Excel General
    Replies: 3
    Last Post: 10-06-2010, 07:56 AM
  5. How to add data to Pivot graph?
    By tkuia in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-01-2009, 09:51 AM
  6. pivot graph
    By cutsygurl in forum Excel General
    Replies: 1
    Last Post: 10-12-2005, 05:05 PM
  7. [SOLVED] Graph with pivot table
    By Richard Vajsar in forum Excel General
    Replies: 1
    Last Post: 07-18-2005, 07:05 PM

Tags for this Thread

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