+ Reply to Thread
Results 1 to 4 of 4

chart data and placement

  1. #1
    Forum Contributor
    Join Date
    04-01-2015
    Location
    Sydney Australia
    MS-Off Ver
    Office 365 latest
    Posts
    171

    Lightbulb chart data and placement

    Hello,
    i`m struggling to get this graph chart to work.

    I have 3 related questions.

    question 1:
    why is the category name listed as $1 through $10 on the chart and
    1 to 10 in the data series?
    I want it listed as the names in column D.
    question 2:
    I would also like this chart on a new sheet within this work book.
    question 3:
    I`d like the chart to update as I add new rows to calculate into sheet 1
    Screen Shot 2017-03-03 at 12.47.21 AM.png

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,902

    Re: chart data and placement

    It is difficult to see what you are doing based on a picture. It would be more helpful to upload a small sample file.

    Question 1: It is difficult to say from a picture. My first guess is that you have not assigned a range to the horizontal/category axis data for the pie chart. The first thing I would do is to open the Select Data dialog and see what range/values are assigned to the horizontal category axis field. If it is not column D, then Edit this range so that it is pointing to column D.

    Question 2: I think these instructions should still apply to 2011, or something very similar: https://support.office.com/en-us/art...1-1d0788ea783f

    Question 3: Some say that this is an advantage to "formatting" your source range as a data table. I rarely have cause to use data tables in my work, so I would use a dynamic named range for this http://peltiertech.com/dynamic-charts/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-26-2014
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: chart data and placement

    My alternative answers for this are from more of a rookie perspective. MrShorty is probably more technically correct, but these work for me.

    Q1. Not sure why, but here's the fix. Right click on the category names at the bottom. Click on select data ( this is all in the image below). Then click edit on the Horizontal (axis category labels, which is on the right hand side of the pop-up you'll get, and select the range of names in column D.

    Selecter.jpg

    Q2. Click on the chart to select it. Ctrl + X to cut. Go to the sheet you want to put it in. Ctrl + V to paste.

    Q3. You could do a dynamic range, or, you could just select a larger range for your chart data. You currently have 10 rows. If you know your data is going to top out at twenty rows then you can just select rows 1-20 for your chart. Make sure that your sum at G11 is put in at G21. The blank rows won't show up in the chart until there is data in them.

    I hope this helps. If not, the smart people will have something.

    Edited to add: Sorry about that surplus picture.
    Attached Images Attached Images

  4. #4
    Forum Contributor
    Join Date
    04-01-2015
    Location
    Sydney Australia
    MS-Off Ver
    Office 365 latest
    Posts
    171

    Re: chart data and placement

    thanks guys those tips and links were just what I needed both in the short term and for longer term learning (great articles! i`ll be experimenting with those over the weekend, i`ve fixed the issues from them, really appreciate your effort in helping me!!!.

+ 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. VBA Chart - defining Legend placement and size
    By PRodgers4284 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 02-04-2012, 08:08 AM
  2. Replies: 1
    Last Post: 12-02-2011, 10:24 PM
  3. Replies: 2
    Last Post: 05-24-2010, 06:09 PM
  4. Replies: 2
    Last Post: 08-14-2009, 11:24 AM
  5. Auto placement of bar chart labels
    By slicendice in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2008, 08:14 AM
  6. Chart placement
    By Freddie Mac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2006, 10:00 AM
  7. Placement of Chart in Worksheet
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2005, 01:05 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