What's new

Solved Excel Chart Rename Cell help needed

pcRat

New Member
Power User
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.:dinesh:

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

Screenshot (156).png
 

My Computer

System One

  • OS
    8.1
    Computer type
    PC/Desktop
    CPU
    i7-3770K
    Motherboard
    ASRock Z77 Extreme4
    Memory
    16 GB
    Graphics Card(s)
    onboard
    Monitor(s) Displays
    17" 24"
    Hard Drives
    1 TB WD
    PSU
    550w

pcRat

New Member
Power User
Who else likes the Graphic Start Menu in 8 ? (Just trying to get a response even if not about original subject)
 

My Computer

System One

  • OS
    8.1
    Computer type
    PC/Desktop
    CPU
    i7-3770K
    Motherboard
    ASRock Z77 Extreme4
    Memory
    16 GB
    Graphics Card(s)
    onboard
    Monitor(s) Displays
    17" 24"
    Hard Drives
    1 TB WD
    PSU
    550w

Dwarf

The Contemplator, (1963-2013)
Moderator
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 Computer

System One

  • OS
    Windows 8.1 Pro RTM x64
    Computer type
    PC/Desktop
    System Manufacturer/Model
    Dwarf Dwf/11/2012 r09/2013
    CPU
    Intel Core-i5-3570K 4-core @ 3.4GHz (Ivy Bridge) (OC 4.2GHz)
    Motherboard
    ASRock Z77 Extreme4-M
    Memory
    4 x 4GB DDR3-1600 Corsair Vengeance CMZ8GX3M2A1600C9B (16GB)
    Graphics Card(s)
    MSI GeForce GTX770 Gaming OC 2GB
    Sound Card
    Realtek High Definition on board solution (ALC 898)
    Monitor(s) Displays
    ViewSonic VA1912w Widescreen
    Screen Resolution
    1440x900
    Hard Drives
    OCZ Agility 3 120GB SATA III x2 (RAID 0)
    Samsung HD501LJ 500GB SATA II x2
    Hitachi HDS721010CLA332 1TB SATA II
    Iomega 1.5TB Ext USB 2.0
    WD 2.0TB Ext USB 3.0
    PSU
    XFX Pro Series 850W Semi-Modular
    Case
    Gigabyte IF233
    Cooling
    1 x 120mm Front Inlet 1 x 120mm Rear Exhaust
    Keyboard
    Microsoft Comfort Curve Keyboard 3000 (USB)
    Mouse
    Microsoft Comfort Mouse 3000 for Business (USB)
    Internet Speed
    NetGear DG834Gv3 ADSL Modem/Router (Ethernet) ~4.0 Mb/sec (O2)
    Browser
    IE 11
    Antivirus
    Avast! 8.0.1497 MalwareBytes 1.75.0.1300
    Other Info
    Optical Drive: HL-DT-ST BD-RE BH10LS30 SATA Bluray
    Lexmark S305 Printer/Scanner/Copier (USB)
    WEI Score: 8.1/8.1/8.5/8.5/8.25
    Asus Eee PC 1011PX Netbook (Windows 7 x86 Starter)

pcRat

New Member
Power User
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.
 

Attachments

  • Excel Chart Problem.zip
    11.8 KB · Views: 40

My Computer

System One

  • OS
    8.1
    Computer type
    PC/Desktop
    CPU
    i7-3770K
    Motherboard
    ASRock Z77 Extreme4
    Memory
    16 GB
    Graphics Card(s)
    onboard
    Monitor(s) Displays
    17" 24"
    Hard Drives
    1 TB WD
    PSU
    550w

Dwarf

The Contemplator, (1963-2013)
Moderator
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: View attachment Experiment 1a.zip
 

My Computer

System One

  • OS
    Windows 8.1 Pro RTM x64
    Computer type
    PC/Desktop
    System Manufacturer/Model
    Dwarf Dwf/11/2012 r09/2013
    CPU
    Intel Core-i5-3570K 4-core @ 3.4GHz (Ivy Bridge) (OC 4.2GHz)
    Motherboard
    ASRock Z77 Extreme4-M
    Memory
    4 x 4GB DDR3-1600 Corsair Vengeance CMZ8GX3M2A1600C9B (16GB)
    Graphics Card(s)
    MSI GeForce GTX770 Gaming OC 2GB
    Sound Card
    Realtek High Definition on board solution (ALC 898)
    Monitor(s) Displays
    ViewSonic VA1912w Widescreen
    Screen Resolution
    1440x900
    Hard Drives
    OCZ Agility 3 120GB SATA III x2 (RAID 0)
    Samsung HD501LJ 500GB SATA II x2
    Hitachi HDS721010CLA332 1TB SATA II
    Iomega 1.5TB Ext USB 2.0
    WD 2.0TB Ext USB 3.0
    PSU
    XFX Pro Series 850W Semi-Modular
    Case
    Gigabyte IF233
    Cooling
    1 x 120mm Front Inlet 1 x 120mm Rear Exhaust
    Keyboard
    Microsoft Comfort Curve Keyboard 3000 (USB)
    Mouse
    Microsoft Comfort Mouse 3000 for Business (USB)
    Internet Speed
    NetGear DG834Gv3 ADSL Modem/Router (Ethernet) ~4.0 Mb/sec (O2)
    Browser
    IE 11
    Antivirus
    Avast! 8.0.1497 MalwareBytes 1.75.0.1300
    Other Info
    Optical Drive: HL-DT-ST BD-RE BH10LS30 SATA Bluray
    Lexmark S305 Printer/Scanner/Copier (USB)
    WEI Score: 8.1/8.1/8.5/8.5/8.25
    Asus Eee PC 1011PX Netbook (Windows 7 x86 Starter)

strollin

Old Guys Rule!
VIP Member
Pro User
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.
 

Attachments

  • Experiment 1b.zip
    11.9 KB · Views: 33
Last edited:

My Computer

System One

  • OS
    W10 Pro (desktop), W10 (laptop), W10 Pro (tablet)
    Computer type
    PC/Desktop
    System Manufacturer/Model
    Home built i7-8700K, Hp Envy x360 EVO Laptop, MS Surface Pro 7
    CPU
    3.7Ghz Core i7-8700K, 11th Gen Core i7-1165G7 4.7Ghz, 10th Gen Core™ i5-1035G4 1.1Ghz
    Motherboard
    ASUS TUF Z370-Pro Gaming, HP, MS
    Memory
    16G, 8G, 8G
    Graphics Card(s)
    AMD Radeon RX580, Intel Iris X Graphics, Intel Iris Plus Graphics G4
    Sound Card
    ATI High Definition Audio (Built-in to mobo)
    Monitor(s) Displays
    Dual Samsung U32J59 32 inch monitors, 13.3" display, 12.3" display
    Screen Resolution
    3840x2160 (Desktop), 1920x1080 (laptop), 2736x1824 Pro 7
    Hard Drives
    500GB ssd boot drive with 2 & 10TB Data (Desktop), 512GB ssd (laptop), 128GB SSD (tablet)
    PSU
    Corsair CX 750M
    Case
    Antec 100
    Cooling
    Coolermaster CM 212+
    Keyboard
    IBM Model M - used continuously since 1986
    Mouse
    Microsoft IntelliMouse
    Internet Speed
    665Mbps/15Mbps down/up
    Browser
    FireFox, MS Edge
    Antivirus
    Defender on all
    Other Info
    Retired in 2015 after working in the tech industry for 41 years. First 10 years as a Technician, the rest as a programmer/software engineer. After 1 year of retirement, I was bored so went back to work as a Robotic Process Automation Consultant. Retired for 3rd (and final) time in 2019.

Dwarf

The Contemplator, (1963-2013)
Moderator
That's much easier than my method, however I must admit that Excel is not my strongpoint.
 

My Computer

System One

  • OS
    Windows 8.1 Pro RTM x64
    Computer type
    PC/Desktop
    System Manufacturer/Model
    Dwarf Dwf/11/2012 r09/2013
    CPU
    Intel Core-i5-3570K 4-core @ 3.4GHz (Ivy Bridge) (OC 4.2GHz)
    Motherboard
    ASRock Z77 Extreme4-M
    Memory
    4 x 4GB DDR3-1600 Corsair Vengeance CMZ8GX3M2A1600C9B (16GB)
    Graphics Card(s)
    MSI GeForce GTX770 Gaming OC 2GB
    Sound Card
    Realtek High Definition on board solution (ALC 898)
    Monitor(s) Displays
    ViewSonic VA1912w Widescreen
    Screen Resolution
    1440x900
    Hard Drives
    OCZ Agility 3 120GB SATA III x2 (RAID 0)
    Samsung HD501LJ 500GB SATA II x2
    Hitachi HDS721010CLA332 1TB SATA II
    Iomega 1.5TB Ext USB 2.0
    WD 2.0TB Ext USB 3.0
    PSU
    XFX Pro Series 850W Semi-Modular
    Case
    Gigabyte IF233
    Cooling
    1 x 120mm Front Inlet 1 x 120mm Rear Exhaust
    Keyboard
    Microsoft Comfort Curve Keyboard 3000 (USB)
    Mouse
    Microsoft Comfort Mouse 3000 for Business (USB)
    Internet Speed
    NetGear DG834Gv3 ADSL Modem/Router (Ethernet) ~4.0 Mb/sec (O2)
    Browser
    IE 11
    Antivirus
    Avast! 8.0.1497 MalwareBytes 1.75.0.1300
    Other Info
    Optical Drive: HL-DT-ST BD-RE BH10LS30 SATA Bluray
    Lexmark S305 Printer/Scanner/Copier (USB)
    WEI Score: 8.1/8.1/8.5/8.5/8.25
    Asus Eee PC 1011PX Netbook (Windows 7 x86 Starter)

pcRat

New Member
Power User
Both ways work and I appreciate your help.

Thank you
 

My Computer

System One

  • OS
    8.1
    Computer type
    PC/Desktop
    CPU
    i7-3770K
    Motherboard
    ASRock Z77 Extreme4
    Memory
    16 GB
    Graphics Card(s)
    onboard
    Monitor(s) Displays
    17" 24"
    Hard Drives
    1 TB WD
    PSU
    550w
Top