+ Reply to Thread
Results 1 to 7 of 7

First chart creation--will only gather date form last 2 cells selected

  1. #1
    Registered User
    Join Date
    02-13-2017
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    4

    First chart creation--will only gather date form last 2 cells selected

    Hello, I am creating my first Excel chart (pie chart). I have one column of data to use as labels and one column of numbers, 20 rows long two rows wide with titles in the cells above. I have tried numerous tutorials and it looks so simple-- select all of the cells click insert and type of chart and the chart appears. But not for me. Tearing my hair out trying. It will create a chart box and only include the data from the bottom 2 cells selected not the entire group, so no chart is actually created--just an empty box.

    Any ideas on how to get all of the data from both column into the chart? Thanks so much for any help!

    pic chart pic.png

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: First chart creation--will only gather date form last 2 cells selected

    Not sure that this will be helpful, however I made the following pie chart by selecting one cell from the table and then pressing the following keys Alt + N + Q.
    It would help us to be of more help to you if you could upload the actual workbook from which the screen shot in post #1 was made. To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    02-13-2017
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    4

    Re: First chart creation--will only gather date form last 2 cells selected

    Thank you JetMc. I am uploading a workbook that is doing the same thing-- I no longer have the original. I did try alt n q but the same thing happened. I think I have managed to attach it using the manage attachments link.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: First chart creation--will only gather date form last 2 cells selected

    The issue here is that the values in B5:B14 are text values (indicator is that they are all left aligned whereas Excel right aligns numbers).
    1) select B5:B14
    2) press the Ctrl and 1 keys
    3) select Number
    4) retype numbers B5 => 1,...B14=> 4
    5) with B14 selected press the Alt + N + Q + Enter keys.
    Let us know if you have any questions.

  5. #5
    Registered User
    Join Date
    02-13-2017
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    4

    Talking Re: First chart creation--will only gather date form last 2 cells selected

    Yesssss!!!!! Thank you JetMC!!!

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: First chart creation--will only gather date form last 2 cells selected

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

  7. #7
    Registered User
    Join Date
    02-13-2017
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    4

    Re: First chart creation--will only gather date form last 2 cells selected

    I tried to mark as solved but there does not seem to be an option for that under thread tools. Only subscribe to this thread or a display option.

+ 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: 4
    Last Post: 11-30-2015, 03:58 PM
  2. [SOLVED] Convert Chart Creation Macro to Stacked Column Chart
    By JBeaucaire in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-24-2014, 01:08 PM
  3. Locking Selected Cells When Form Button is Pressed. HELP!
    By naila.obnial in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-09-2013, 03:09 AM
  4. Macro to gather informations from a form and compile it
    By galegai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2012, 04:42 PM
  5. Excel file creation dates do not match the windows creation date.
    By alexthapyro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2011, 12:14 PM
  6. Invalid property error loading a form with a date selected form DTPicker
    By copernicus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2009, 04:17 PM
  7. Copy rows to new sheet based on date range selected on a form
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-19-2009, 11:40 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