+ Reply to Thread
Results 1 to 2 of 2

Using different data in data table as part of column chart

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Using different data in data table as part of column chart

    Hi guys,

    Can anyone advise if/how it's possible to use different data in my table below my chart? see attached file.

    I want to use the data for B2:B6 and C2:C6 in my table below my chart\? can anyone help please?

    thank you!
    Attached Files Attached Files
    Thanks,

    R.



  2. #2
    Forum Contributor
    Join Date
    09-05-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    383

    Re: Using different data in data table as part of column chart

    As far I can see - not directly but you could do something similar.

    Remove the data table from the chart and change the outer border colour to white (invisible)

    Create your own Chart within the worksheet and strategically position your chart above it, remove the gridlines from the worksheet and you'll have something that looks about as close as I think you can - to what you want.

+ 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: 3
    Last Post: 07-19-2018, 03:50 PM
  2. Replies: 0
    Last Post: 11-06-2014, 07:25 PM
  3. [SOLVED] Column chart using Dynamic Data Table
    By mstoto in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 08-06-2014, 02:17 PM
  4. Getting a Cel lReference into PART of a chart data range!?
    By mimottershaw in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-25-2013, 02:37 PM
  5. Chart only a part of a large data set
    By delboy2405 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-24-2008, 05:03 AM
  6. Create chart where user select part of data
    By Endorphin in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-23-2008, 06:50 AM
  7. How do I hide part of a data series in a chart?
    By Jeff Bremer in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-25-2006, 02:40 PM

Tags for this Thread

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