Results 1 to 11 of 11
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Duplicating Charts (Excel 2003/SP2)

    I think I've proven to my own satisfaction that it won't work, but perhaps someone else can prove me wrong.

    Is there a method for creating a chart that will update its' source data automatically depending on where it is copied to on the sheet?
    Attached Images Attached Images
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Duplicating Charts (Excel 2003/SP2)

    Does it have to be literally duplicated?

    Why not create one chart from all the data and have each row a separate column in the chart. Then adjust the size of the one chart to meet your needs. The added advantage is that formatting the colors can be done much more easily

    See Example

    Steve
    Attached Files Attached Files

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicating Charts (Excel 2003/SP2)

    Hi Catherine

    I usually get the wrong end of the stick when I try to help so please ignore if of no use. Many moons ago I wanted to use the REPT function to visually show a numeric value as a bar value, I had the basics in a an example in this post - <post#=672,522>post 672,522</post#> - I then had some excellent answers so that it could be adapted and modified.

    I hope this helps

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Duplicating Charts (Excel 2003/SP2)

    Well, of course - do it the easy way <img src=/S/grin.gif border=0 alt=grin width=15 height=15> doesn't that take all the fun out it!

    I must have been suffering a severe case of tunnel vision - I think your solution looks WAY better than mine and now I will steal it!
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Duplicating Charts (Excel 2003/SP2)

    I hadn't thought about the rept function. Thanks for reminding me.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Duplicating Charts (Excel 2003/SP2)

    So get me out of my misery, is the Spark Bar you illustrate an Excel add-in?
    Jerry

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Duplicating Charts (Excel 2003/SP2)

    Unfortunately, I had to do it the easy way since I could not really figure out a way to do what you asked for. I figured if I couldn't give you what you wanted, I could give you what you needed [Perhaps there is a song in there somewhere...] <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    But, there is no need to steal it, as I freely offered it to you... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Steve

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Duplicating Charts (Excel 2003/SP2)

    I don't think so. I think Catherine was creating a separate chart in each cell and copying it down but had to edit the ranges for each row (hence the question). I recommended using a standard chart adjuested to display what she wanted it to look like.

    Steve

  9. #9
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Duplicating Charts (Excel 2003/SP2)

    No, although I did Google some.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  10. #10
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Duplicating Charts (Excel 2003/SP2)

    SteveH's suggestion would copy down nicely. But I couldn't get it to look the way I wanted.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  11. #11
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Duplicating Charts (Excel 2003/SP2)

    I'm going to test this out
    http://sparklines-excel.blogspot.com/
    It creates the charts from shapes generated by UDF's
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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