Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel Chart question


  • Please log in to reply

#1
OR_Mtn_Man

OR_Mtn_Man

    Member

  • Member
  • PipPip
  • 10 posts
I have an Excel spreadsheet that I update with weekly stats. I have around 20 charts that I maintain showing various historical stats. Whenever I add a new week to the spreadsheet I have to go in and manually change the value in the Source Data for each chart. Is there a way to do a global replace of the cell? For example, this week the column of the cell value is set to $CK. Next week I will have to change this to $CL. I have tried the Find/Replace option but it does not look in Source Data.
  • 0

Advertisements


#2
Jrenter2

Jrenter2

    Member

  • Member
  • PipPipPip
  • 435 posts
Hi OR_Mtn_Man,

Are these charts on 20 different worksheets or combined all in one?
  • 0

#3
OR_Mtn_Man

OR_Mtn_Man

    Member

  • Topic Starter
  • Member
  • PipPip
  • 10 posts
Jrenter2 - Thanks for the reply, they are all on one spreadsheet.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP