Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert new data in chart (Office 2000)

    Hello,

    Is there any way to insert in a chart extra data which is taken from a link?

    I have a chart (see attached), which is linked to a data sheet in the same file. The user now wants to also see in a small box at the top of each series the % changes between the two numbers (between the red and blue columns). I can make that with a textbox manually, however as the data is changing every month, I want this data to automatically be updated correctly. I am not sure how to go about it. Was thinking to insert a new data series, but it will show as a third column next to the other two, which I don't want. I also tried to add the link to this % change calculation in the textbox (=Sheet1!$A$16), but it won't accept it as a link to my data sheet. Any ideas how to do this? The two boxes with text in red (arrow next to them) is what I want to have in my chart and to be linked to the % change calculation in the other sheet.

    Thanks in advance!
    K.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts

    Re: Insert new data in chart (Office 2000)

    Instead of entering actual percent values in the text boxes link the textbox displayed value to a cell.
    Click in the textbox and then in the formula bar type
    =PercentValue1
    where you have assigned the range name 'PercentValue1' to a cell which contains the required value.
    Ditto for the second textbox, e.g. use 'PercentValue2' or whatever.


    zeddy

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert new data in chart (Office 2000)

    Oh, brilliant, the link works now fine, thanks a lot. Great idea with naming the ranges, haven't thought of that.

    Regards,
    K

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •