+ Reply to Thread
Results 1 to 2 of 2

compare monthly figures in one chart

  1. #1
    Forum Contributor
    Join Date
    08-08-2008
    Location
    Belfast
    Posts
    112

    compare monthly figures in one chart

    Probably an easy one but can figure it out.

    I wish to use a chart to show the changes in data entries in a survey held monthly (21 question survey)

    I would like to compile a chart showing the answers for each month side by side i.e. Jan question 1 beside Feb question 1 Jan question 2 beside Feb question 2 etc etc.

    I have the data stored in columns say b3 - b24 for Jan b26 - b41 for Feb and so on

    Any help appreciated

  2. #2
    Registered User
    Join Date
    03-31-2014
    Location
    dubai
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: compare monthly figures in one chart

    Use the technique mentioned here

    http://www.brainbell.com/tutorials/E...rt-ranges.html

    Another (and probably the easy) way is to arrange your data like this Column B = Jan data, Column C = Feb Data, Column D = Mar Data and so on.
    Last edited by smb_146; 09-20-2014 at 02:17 PM.

+ 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: 0
    Last Post: 09-12-2010, 12:56 PM
  2. sum up monthly figures.
    By coolhit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2009, 02:53 AM
  3. capture monthly figures
    By Sal_m_78 in forum Excel General
    Replies: 5
    Last Post: 10-16-2008, 09:28 AM
  4. [SOLVED] Compare 1 yr's figures with another in a chart
    By Annie1904 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2006, 08:00 AM
  5. [SOLVED] compare small and large figures in one chart
    By duha in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-15-2006, 03:55 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