+ Reply to Thread
Results 1 to 3 of 3

Organizing Data Table in a Bar Chart Layout 5

  1. #1
    Registered User
    Join Date
    12-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    10

    Organizing Data Table in a Bar Chart Layout 5

    Hello,

    I have a bar chart that monitors month over month activity. I use Layout 5, which allows for the numbers data to neatly be organized in a table below the bar chart. However, i recently started using the data on a secondary axis to accurately reflect trend lines. It works great, but now the data table below displays redundant information. see attachment.

    example.jpg


    I just want that data in the data table to be displayed once, completely leaving of the axis legend. Can anyone assist?

    Thanks!!!!!

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

    Re: Organizing Data Table in a Bar Chart Layout 5

    Control over the data table is very limited. It displays all the series in the chart without the option to hide any.

    You could fake the appearance by using 2 charts layered on top of each other.
    Or use worksheet cells to display the table data.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Organizing Data Table in a Bar Chart Layout 5

    Wow! Such a simple but brilliant idea! Never would have thought of that but makes sense.

    Thanks!!!!
    Dan

+ 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. Rearranging a data table into a different layout
    By pauldaddyadams in forum Excel General
    Replies: 10
    Last Post: 10-28-2013, 03:37 PM
  2. Help with organizing data-pivot table
    By putitwhere in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 04-30-2013, 08:18 PM
  3. Survey Data -- Table Layout
    By Dmerric1 in forum Excel General
    Replies: 0
    Last Post: 08-27-2012, 10:39 AM
  4. data layout for a stacked bar chart
    By lwilson21 in forum Excel General
    Replies: 5
    Last Post: 06-16-2011, 04:31 AM
  5. Help organizing data using Pivot Table
    By Branden in forum Excel General
    Replies: 0
    Last Post: 03-21-2006, 02: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