+ Reply to Thread
Results 1 to 3 of 3

ReFormatting points to lines in XY scatrer charts with 6 charts on each tab.

  1. #1
    Registered User
    Join Date
    01-15-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    25

    ReFormatting points to lines in XY scatrer charts with 6 charts on each tab.

    I've got lots of multiple tabs, each with 6 similarly named and positioned chart objects and want to reformat all the charts to that each chart's chart will be changed from showing points to lines. Once each page's chart are reformatted I would like it to select the next tab and make it active.

    Below is a copy of the macro I've recorded and fussed with a bit, but it doesn't seem to work. Any ideas?

    -Niedermee



    Please Login or Register  to view this content.
    Last edited by Fotis1991; 01-15-2014 at 01:53 PM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: ReFormatting points to lines in XY scatrer charts with 6 charts on each tab.

    Welcome to the forum.

    We'd like to help you but first..

    Pls take some minutes to read forum rules and specially-in this case- rule#3
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    01-15-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: ReFormatting points to lines in XY scatrer charts with 6 charts on each tab.

    Thanks for the heads up.

    Please Login or Register  to view this content.
    Last edited by Fotis1991; 01-15-2014 at 01:54 PM. Reason: No edititing but just to add code tags in your first post is enough!

+ 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. Reformatting data labels for Excel pie charts
    By krabople in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-26-2009, 09:38 AM
  2. Categorise points in scatter charts
    By DanHegarty in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-07-2008, 09:35 AM
  3. how to find intersections points of lines in charts
    By Ani in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-06-2006, 09:25 AM
  4. Global macro for resizing and reformatting Excel charts
    By Sol Apache in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-23-2005, 11:05 PM
  5. Data Points on Charts in MS Excel
    By Verl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2005, 11:05 PM

Tags for this Thread

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