+ Reply to Thread
Results 1 to 2 of 2

chart that utilizes alternating columns?

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    chart that utilizes alternating columns?

    I am tracking my employees while they telework and need to create a chart to help. I have create a table for the number of calls, but I also need to add in the average length. I have created a chart for the number of calls, but how can i add the data for the average length without screwing up my chart? So in my attachment the top table is what I use now, the bottom table is what I would like to use. How can i accomplish this? Thanks!
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 03-23-2020 at 11:49 AM. Reason: Title shortened Please keep to the essentials

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: chart that utilizes alternating columns?

    The textbook method would be to use a single row for each data point instead of using a table. I see why you want to view the data like your example, but a good design separates how to enter the data vs. how to view the data. I have shown a Data Entry sheet, and then a View Data sheet that uses a pivot table. You did not provide Avg Min values so I made some up.

    Now you enter the data on Data Entry, and then refresh the pivot table on the View sheet and it looks like your desired sheet. (right-click anywhere in the table and click Refresh).

    I added another pivot table/chart combination on the View page to show chart you want. The data is organized differently to give the chart format you want.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] 12 hour workday with alternating days and alternating weeks
    By codemancode in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-12-2019, 01:23 PM
  2. [SOLVED] Summing of Alternating Columns
    By heyhsia in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-14-2019, 06:44 PM
  3. Replies: 1
    Last Post: 12-17-2018, 05:42 PM
  4. delete columns alternating
    By jszmaia in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-21-2013, 02:51 PM
  5. [SOLVED] Create alternating rows
    By Scibola in forum Excel General
    Replies: 2
    Last Post: 04-09-2013, 04:19 PM
  6. Alternating Values in Columns
    By Synchrony in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2013, 08:42 PM
  7. [SOLVED] Create stacked columns chart but with 2 columns for each x axis?
    By PSM in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-07-2005, 11:06 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