Windows 8 and 8.1 Forums


Excel Chart Rename Cell help needed

  1. #1

    Excel Chart Rename Cell help needed


    I should probably quit trying to do new things with Excel but everything opens a new door.

    I finally learned to make a chart. Change the title. Even rename Series 1 , 2 & 3 at bottom.

    BUT, for the life of me I cannot figure out how to rename the cells labeled 1 , 2 , 3 , 4 & 5 at the bottom. And I know it is easy.

    Click image for larger version

      My System SpecsSystem Spec

  2. #2


    Who else likes the Graphic Start Menu in 8 ? (Just trying to get a response even if not about original subject)
      My System SpecsSystem Spec

  3. #3



    The Contemplator
    (1963-2013)
    Doncaster, UK
    Posts : 638
    Windows 8.1 Pro RTM x64


    Can you attach the .xls file to your reply, and I'll take a look (or someone else will). You will need to zip the file first.
      My System SpecsSystem Spec

  4. #4


    Here it is and I appreciate you or someone else looking at it.
    Mainly what I want to do is rename 1 to Income , 2 to Bills then Personal Money , Paid , Actual Personal Money & Over / Short.

    I can rename 1 but then the rest disappear. And if I start over, rename 3 instead of 1 , it changes the name on 1 and 2-6 disappear again. I may not know how to spell krazzee but I know how it feels.
    Excel Chart Rename Cell help needed Attached Files
      My System SpecsSystem Spec

  5. #5



    The Contemplator
    (1963-2013)
    Doncaster, UK
    Posts : 638
    Windows 8.1 Pro RTM x64


    Ok, here you go. It's a bit convoluted, but it works.

    1. Click on C2 and type Income
    2. Click on the chart
    3. Click on Chart Filters (the 3rd icon down, representing a funnel)
    4. Click on Select Data...
    5. In the dialogue box Chart data range: (already highlighted), edit it to read as follows: =Sheet1!$C$2:$G$2,Sheet1!$C$4:$G$8
    6. Click OK
    7. Click on Chart Filters and Select Data... again
    8. Refer to the panel headed Legend Entries (Series)
    9. Click on Series1 and then Edit
    10. In the Series name: dialogue box (the cursor should already be flashing there), type =(Sheet1!$D$1)
    11. Click OK
    12. Repeat steps 9-11 for each of the other names to be added, remembering to use the correct data reference in step 10 (2=E, 3=F, and 4=G)


    Here is the resultant file: Experiment 1a.zip
      My System SpecsSystem Spec

  6. #6


    N. Calif
    Posts : 2,582
    W10 Pro (desktop), W10 (laptop), W10 Pro (tablet), W10 (laptop)


    It's not quite as convoluted as Dwarf posted. You need all of the chart headings in a row or columns as you want them. I inserted the text "Income" into cell C2 and used the rest of column C as the chart headings. Next, click on the chart to select it, then click on Chart Tools, then click on "Select Data". A "Select Data Range" dialog will appear. Click on "Edit" under the Horizontal Axis labels and in the range box that pops up enter "=(Sheet1!$C$2,Sheet1!$C$4,Sheet1!$C$5,Sheet1!$C$6,Sheet1!$C$7,Sheet1!$C$8)" then click OK, then OK again and Voila, your chart labels have been changed.

    Alternatively, instead of simply entering the text into the range box that pops up, you could click on the little spreadsheet icon and then hold down the Ctrl key and click on cells C2, C4, C5, C6, C7 and C8 then press Enter.

    Note: This is using Excel 2007, not sure which version you are using. It works the same in Excel 2013, I didn't try 2010.
    Excel Chart Rename Cell help needed Attached Files
    Last edited by strollin; 25 Sep 2013 at 11:04.
      My System SpecsSystem Spec

  7. #7



    The Contemplator
    (1963-2013)
    Doncaster, UK
    Posts : 638
    Windows 8.1 Pro RTM x64


    That's much easier than my method, however I must admit that Excel is not my strongpoint.
      My System SpecsSystem Spec

  8. #8


    Both ways work and I appreciate your help.

    Thank you
      My System SpecsSystem Spec

Excel Chart Rename Cell help needed
Related Threads
Hi, I have been facing this issue for many months. Whenever i add comments to excel cells, it appears different from other comment sometime, please check the screenshots. Let me tell you in all cases the comment font style (type, size, bold etc) is same. 51023 51024
Read more at: Cell phone unlocking will be legal again | ZDNet
Maybe this can't be done. Column D is my bank balance and I don't want everyone seeing it. Especially my wife who tends to spend more at the store if she sees it while I figure how much she can spend. What I'm trying to do is to keep only the last 4 digits visible. 549.67 would only...
Hello, I am beginning to suspect this is not possible. What I want is to have a column with "notes" in which the cells (and the rows with them) expand downwards to accommodate additional text. Can this be done? All the online tutorials just seem to think people want lots of nice additional...
Show us your cell phone! in Chillout Room
So people,mine is Xperia X8 http://st2.gsmarena.com/vv/bigpic/se-x8.jpg Your?
Bluetooth & Cell Phone in Network & Sharing
As I understand it, I should be able to link my new Win8 touch screen notebook (Asus X202e) with my Android cel phone (Moto Droid X2) so that I can quickly and easily exchange photos and files - I think I should be able to see the entire contents of one device on the other? Anyway, I've...
Windows 8 reminds me of a cell phone or a gizmo to put in your front pocket. When I sit down to my main computer that is what I expect "A Computer", not an oversize cell phone.
Eight Forums Android App Eight Forums IOS App Follow us on Facebook