+ Reply to Thread
Results 1 to 6 of 6

Chart to show yearly variance

Hybrid View

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Cleveland, TN
    MS-Off Ver
    Excel 2007
    Posts
    53

    Chart to show yearly variance

    Hi,

    I am having issues making a chart. I need 5 categories from 2013 compared to the same 5 of 2014.
    Can break it down to 1 category with 5 charts if it is easier. I need this to be a line graph. It needs to be in Sheet2.
    Attached is the file i am working with.

    Mony Report.xlsx

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Chart to show yearly variance

    Yes... but are you wanting to plot the daily variances or one of the summary variances at the foot of the data. If the summary data, which set of summary data?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    08-16-2012
    Location
    Cleveland, TN
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Chart to show yearly variance

    Hello,

    Yes, I need the daily variances. It'll be a huge chart I know

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Chart to show yearly variance

    Mmmmm. And maybe hard to follow, too...

    Never mind that it's on the wrong sheet. This plots variance for "cases" against the date. Is this what you had wanted?? If not what needs to be modified and we can tidy it up a bit...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-16-2012
    Location
    Cleveland, TN
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Chart to show yearly variance

    I'd like to see a line for 2013 for cases(and other categories as well), and another line for 2014.
    It should show the fluctuations between each year.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Chart to show yearly variance

    Closer? If not, we'll try again...
    Attached Files Attached Files

+ 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. Pivot chart from monthly to yearly
    By gengiskhan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-22-2014, 05:54 PM
  2. Show Variance in Inventory based on Product Numbers
    By msdclark in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-28-2014, 10:28 AM
  3. want to show variance in a chart
    By itsmesunilb in forum Excel General
    Replies: 0
    Last Post: 03-09-2012, 03:36 AM
  4. Variance in Chart
    By excelhelp18 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-20-2010, 03:57 AM
  5. Show Variance between 2 lines in Graph
    By iamamonkeysoareyou@gmail.com in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-06-2006, 11:25 AM

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