+ Reply to Thread
Results 1 to 2 of 2

Display Chart on alternative sheet

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    35

    Display Chart on alternative sheet

    Hi All

    How can I create and maintain charts from Sheets 2 and 3 (for example), but also copy and see any changes made over to sheet 1? So if I change sheet 2 data, resulting in a change to the chart, I'd like the change to show on Sheet 1 without having to do anything. I'd also like to regularly change headings which should be carried to sheet 1 too (if this requires anything different, but I'm hoping ANY change to the chart will be reflected on the main sheet (Sheet 1))

    Thanks in advance

  2. #2
    Registered User
    Join Date
    02-01-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    10

    Re: Display Chart on alternative sheet

    See attached for an example. jasonjhc.xlsx
    Data, axis labels and headings can all be carried over to Sheet 1.
    However, chart formatting cannot be carried to Sheet 1 without using VBA.
    You will need to decide on the formatting before you copy and paste the charts over to Sheet 1.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MsgBox to display an alternative Message
    By akynyemi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2013, 08:15 PM
  2. [SOLVED] Can Chart display 2 year at a time in attached sheet
    By sumonrezadu in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-26-2012, 02:02 PM
  3. [SOLVED] how to open display the chart by clicking the cell in excel sheet
    By shankar.s in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-22-2006, 09:50 AM
  4. Replies: 1
    Last Post: 02-08-2006, 12:40 AM
  5. [SOLVED] Format a number to display as alternative text
    By Terrafutan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2005, 05:05 AM

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