Results 1 to 2 of 2
  1. #1
    bradleyg is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2013
    Posts
    12

    Copy Chart Change Data


    Hi and thank you for looking at my question. I just created a chart in a report from a query - sales - (I formatted it the way I want, colors bar size etc) I copied the chart and pasted it on the report now I would like to change the data to Profit. Same query just different data. Is there a way for me to just change the data from sales to profit so I don't have to rebuild the chart?
    any help will do.

    thanks

    Brad

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,648
    How can it be the same query?

    What happens when you change the chart RowSource property?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can't copy or change some reports.
    By khughes46 in forum Reports
    Replies: 4
    Last Post: 04-08-2015, 04:00 PM
  2. Change chart title with code
    By Pastor Del in forum Reports
    Replies: 6
    Last Post: 02-11-2014, 08:56 PM
  3. Change chart type
    By jtan in forum Reports
    Replies: 1
    Last Post: 11-12-2013, 02:24 AM
  4. Chart axis change with .Chartype changes
    By alangea in forum Programming
    Replies: 2
    Last Post: 05-20-2012, 12:41 PM
  5. ole chart copy to clip
    By jtkjames in forum Programming
    Replies: 4
    Last Post: 07-28-2010, 11:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums