Results 1 to 1 of 1

Stop cell reference from changing in a chart series

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2012
    Location
    Mississauga Ontario
    MS-Off Ver
    Excel 2007
    Posts
    2

    Stop cell reference from changing in a chart series

    I have a chart in which I daily insert a column. For reference sake this is the formula =SERIES(,Database!$C$2:$EB$2,Database!$C$25:$EB$25,1).
    Whenever I insert the column the formula will shift one column and become =SERIES(,Database!$D$2:$EC$2,Database!$D$25:$EC$25,1). So what happens is that my inserted column does not automatically get included into the chart.
    How do I keep the range static so that each day I'm plotting my new data.
    I hope I've explaned my problem properly.
    thanks
    Last edited by ruggedcashew; 02-24-2012 at 09:24 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1