+ Reply to Thread
Results 1 to 4 of 4

Labeling A Graph

  1. #1
    Registered User
    Join Date
    01-05-2016
    Location
    Heaven
    MS-Off Ver
    Mac 2011
    Posts
    2

    Labeling A Graph

    Hi,

    I have a pretty maddening issue and I'm pretty sure it's easy to figure out but I can't. I simply need to name each column, and I plan on labeling them: "column 1," "column 2," etc. I also need to name what is currently titled "Series" into "Row 1," "Row 2," etc. How do I do this?? For some reason I can't seem to find a way. Thanks to those who help!

    Screen Shot 2016-01-05 at 12.30.51 AM.png
    Attached Images Attached Images

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

    Re: Labeling A Graph

    Assuming I understand what labels you want where, in a 3D column chart like this:

    1) Go into the "Select Data" dialog (Chart group->Design tab, I think is where it should be in 2011).
    2) Assuming the "column" labels (column1, column2, column3,...) are convenient in the spreadsheet, make sure the "horizontal category axis" range is pointing to the range containing the column labels.
    3) The "row"/series labels are the "name" field for each data series. So, select each data series, click "Edit", then make sure the "Name" field is pointing to the proper cell on the sheet (or contains the proper text).
    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
    01-05-2016
    Location
    Heaven
    MS-Off Ver
    Mac 2011
    Posts
    2

    Re: Labeling A Graph

    Thank you so much! I also had another question. Do you know if Excel lets your turn the graph rotatable by 360 degrees on an xyz axis. I plan on posting this graph on a website, and I was hoping that viewers can rotate the graph in every direction. Is that possible with excel?

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Labeling A Graph

    I may be overly optimistic, but I tend to think almost anything is possible with enough time, energy, skill, and ingenuity.

    From within Excel, you can bring up the "format chart area" dialog, click on "3D rotation" and change the parameters there to rotate the view of the 3D chart. Doing this from a webpage will probably depend on your and the viewer's ability to manipulate these parameters from the webpage. Since I have no experience with browser based programming, I will have to defer to those more knowledgeable in that area of expertise.

+ 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. Need help labeling what I need to learn to do
    By synses in forum Excel General
    Replies: 0
    Last Post: 09-29-2012, 12:27 PM
  2. [SOLVED] Labeling duplicates
    By excelsonic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2012, 11:53 AM
  3. Hover labeling
    By stebs in forum Excel General
    Replies: 0
    Last Post: 11-22-2011, 03:49 AM
  4. Axis Graph Labeling
    By EAGLEBUCKS in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-15-2011, 03:31 AM
  5. labeling stacked column graph
    By dadevil in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-30-2010, 05:01 AM
  6. labeling column bins in a bar graph
    By pkhoosh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-02-2008, 04:58 AM
  7. X-axis labeling
    By [email protected] in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-30-2005, 08:35 PM
  8. Labeling of Graph (Data Series)
    By Dustin Deck in forum Excel General
    Replies: 1
    Last Post: 03-28-2005, 07:06 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