How do I set my chart title to the contents of a cell, and then what ever
the cell contents are, the chart title is changed to automatically?
Dean
--
[email protected]
http://www.dkso.co.uk/
http://homepage.ntlworld.com/dkso
How do I set my chart title to the contents of a cell, and then what ever
the cell contents are, the chart title is changed to automatically?
Dean
--
[email protected]
http://www.dkso.co.uk/
http://homepage.ntlworld.com/dkso
Hi,
Here is an explanation,
http://www.andypope.info/tips/tip001.htm
Cheers
Andy
Dkso wrote:
> How do I set my chart title to the contents of a cell, and then what ever
> the cell contents are, the chart title is changed to automatically?
>
> Dean
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Any,
Thanks, just what I was after however I'm going to be greedy now. Is it
possible to add a second line of text to the title?
I can currently edit the title on the graph and add a carriage return and
hence a second line in the title. is this possible, like X&Y sub headings?
Dean
"Andy Pope" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> Here is an explanation,
> http://www.andypope.info/tips/tip001.htm
>
> Cheers
> Andy
>
> Dkso wrote:
>> How do I set my chart title to the contents of a cell, and then what ever
>> the cell contents are, the chart title is changed to automatically?
>>
>> Dean
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
Done it...I've added a text box.
Thanks again
Dean
"Andy Pope" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> Here is an explanation,
> http://www.andypope.info/tips/tip001.htm
>
> Cheers
> Andy
>
> Dkso wrote:
>> How do I set my chart title to the contents of a cell, and then what ever
>> the cell contents are, the chart title is changed to automatically?
>>
>> Dean
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
Hi,
If the cell contains a newline character (ALT+ENTER) or a formula
version CHAR(10) then that should be reflected in the chart title.
Although the formatting of both lines will be the same.
You can use other text elements of the chart to hold cell linked text.
such as x-axis and y-axis titles. By add a dummy data series and setting
it to the secondary axis you can also use the secondary x and y titles.
Also Data labels can be linked.
And as you have done you can embed a textbox within the chart.
Cheers
Andy
Dkso wrote:
> Any,
>
> Thanks, just what I was after however I'm going to be greedy now. Is it
> possible to add a second line of text to the title?
> I can currently edit the title on the graph and add a carriage return and
> hence a second line in the title. is this possible, like X&Y sub headings?
>
> Dean
> "Andy Pope" <[email protected]> wrote in message
> news:[email protected]...
>
>>Hi,
>>
>>Here is an explanation,
>>http://www.andypope.info/tips/tip001.htm
>>
>>Cheers
>>Andy
>>
>>Dkso wrote:
>>
>>>How do I set my chart title to the contents of a cell, and then what ever
>>>the cell contents are, the chart title is changed to automatically?
>>>
>>>Dean
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>
>
>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks