Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

Excel 2010 - Horizontal and Vertical Axis Titles - How to use cell values

Rather than type data into the Axis title boxes, I'd like to refer to a particular cell address.  How can I do this? (see graphic)
err
0
brothertruffle880
Asked:
brothertruffle880
  • 2
1 Solution
 
Saqib Husain, SyedEngineerCommented:
When you select the title as shown in the diagram above you can enter this in the formula bar

=A1
0
 
brothertruffle880Author Commented:
I tried it and got an error message (see graphic)

err
0
 
Saqib Husain, SyedEngineerCommented:
Try adding reference to the sheet name

=Sheet1!A1
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now