+ Reply to Thread
Results 1 to 5 of 5

Column chart to compare different periods

  1. #1
    Registered User
    Join Date
    04-03-2021
    Location
    Zaragoza
    MS-Off Ver
    2102 MICROSOFT 365
    Posts
    52

    Column chart to compare different periods

    Good evening everybody,

    I am not good at Excel and I am having problems to plot a column chart so it shows Q1, Q2, Q3 and Q4 in the horizontal axis and the number of cash deposits and the values of such deposits in the vertical one.
    I will like to plot the one I have on tab "dashboard" where you can put Q2 and Q1 together. When I click on select data and try to put the cell D8 from the cash deposit data Q1 and the same cell but from cash deposit data Q2 it does not allow me to do so.

    Can you kindly help?

    Thank you
    Viewotst
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,986

    Re: Column chart to compare different periods

    Consider changing the layout of your data.

    You can then use pivot table/chart to aggregate the data and display counts and values for selected periods

    For the example I made the values static rather than random so you can get the results
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-03-2021
    Location
    Zaragoza
    MS-Off Ver
    2102 MICROSOFT 365
    Posts
    52

    Re: Column chart to compare different periods

    Agreed, much better your way. Just some questions:

    What do you mean with "I made the values static rather than random so you can get the results"?
    Is there any way that the pivot and the graph get updated if I add more data to the list on the left-hand side or would I have to manually modify the pivot data source to include the new lines in the list and then refresh it and also the graph?

    Last question is about graphs, if you see the image attached, how could I modify the "Horizontal (category) Axis Labels? Letīs say I just want two tick boxes for Q1 and Q2 rather than five of them. There is not remove button option for the Horizontal, only for the legend entries.

    Thanks a lotAttachment 763699

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,986

    Re: Column chart to compare different periods

    I can not see the image in you link. But the Period dropdown in bottom left hand corner of the chart allows for selection of Quarters. As does the slicer. You can also filter the pivot table.

    I was just letting you know I had replaced the formula with values. Using Random function in the data would mean the values would be out of sync after a calculation and you would not see the result of the values plotted in the chart

    If you use a table table you can add new data to the end. Then you would only need to refresh the pivot table.

  5. #5
    Registered User
    Join Date
    04-03-2021
    Location
    Zaragoza
    MS-Off Ver
    2102 MICROSOFT 365
    Posts
    52

    Re: Column chart to compare different periods

    Thank you for your quick response and help.

    I have re-attached the image.

    Thank you
    Viewotst
    Attached Images Attached Images

+ 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. Creating chart for missing periods of time
    By IgorDe in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-14-2019, 09:08 AM
  2. How to compare two sets of data from two different time periods
    By tkoral in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-07-2017, 03:10 PM
  3. [SOLVED] compare stacked column bars in a chart
    By sarinky in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-29-2013, 02:21 AM
  4. Chart for profits of multiple companies in different time periods
    By DerrickRose in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-16-2011, 06:58 PM
  5. Time-series Chart w/ diff x periods
    By bookman3 in forum Excel General
    Replies: 2
    Last Post: 06-14-2010, 07:01 PM
  6. building a chart to display time periods
    By Don Juan in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-21-2009, 07:31 AM
  7. offsetting periods in chart
    By saturnin02 in forum Excel General
    Replies: 2
    Last Post: 01-26-2005, 04:06 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