+ Reply to Thread
Results 1 to 4 of 4

Create buffer space between chart and data table

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Bend, Oregon
    MS-Off Ver
    365 ProPlus
    Posts
    51

    Create buffer space between chart and data table

    Here's the chart, and I've not had to think about doing this before, however I'd like to have the data table moved lower that what it is to create a little more readability.

    Capture.JPG

    Any ideas?

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Create buffer space between chart and data table

    It is ok like this:

    Capture.JPG

    Just set font size for X axes into 30 (for example) and font colour the same as chart background colour.
    With gradient background it can be harder (or not possible).
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    03-07-2013
    Location
    Bend, Oregon
    MS-Off Ver
    365 ProPlus
    Posts
    51

    Re: Create buffer space between chart and data table

    Unfortunately I didn't create this (I'm getting tossed into data analytics without much say...). Maybe it's the chart (which I've tried the font size before and can't delineate the X axis - just the whole chart), which doesn't do any good.

    Maybe I'll see how this was created and then fiddle with it... I've no idea how they got the table in there.

  4. #4
    Registered User
    Join Date
    03-07-2013
    Location
    Bend, Oregon
    MS-Off Ver
    365 ProPlus
    Posts
    51

    Re: Create buffer space between chart and data table

    Ah, got it. I had deleted the X axis and after restoring that with the adjustment of the font size and color that provided spacing. Thanks! I should have remembered all that

    Now the table part to figure out... lol

+ 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] Extract data to create a pivot table/chart
    By ChrisXcel in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-25-2021, 01:04 PM
  2. [SOLVED] Create a Line chart with a table of data
    By JustGoCW in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-25-2018, 10:29 AM
  3. [SOLVED] How to create space after putting a table or picture onto first line of the first page?
    By zanshin777 in forum Word Formatting & General
    Replies: 2
    Last Post: 03-30-2016, 06:52 AM
  4. Create a chart using only certain data from a table
    By ziiviator in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-08-2016, 11:11 PM
  5. Autoheight + buffer space for select rows
    By Uvuriel03 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-29-2013, 04:47 PM
  6. create chart from pivot table data
    By Brontosaurus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2011, 04:51 AM
  7. Automatically create chart sheets from data table
    By AJO in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2007, 09:13 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