+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Chart lines are too thick using default templates and Pivot table/chart

  1. #1
    Registered User
    Join Date
    09-10-2010
    Location
    UK, Marlborough
    MS-Off Ver
    365 (latest beta)
    Posts
    57

    Smile Chart lines are too thick using default templates and Pivot table/chart

    Hello everyone, hope someone here can help.

    Although I have no problem cycling through my chart lines and chaning the thickness (there's a fair few series of data here) I need to provide this chart to a client who will then be able to select pivot chart data and it will automatically chart the relevant lines.

    Currently any additional series I plot doesn't retain the chart style of the previous lines.

    I need the 'Chart style' to have the differing colours (as it is by default) but with a much lower line thickness (due to the proximity of the data points in places I'm using 0.25pt line thickness)

    any ideas?
    Last edited by jraward; 09-13-2010 at 07:01 AM. Reason: Changed title

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: I need to create a template that will dictate the thickness of chart lines

    Have you tried saving your chart as a template and then applying the chart template to a new chart?
    To save as template: select the chart, then click Save As Template in the Chart Tools - Design tab.
    To create a chart based on a template, select the data (or an existing chart), click Insert - click any one of the chart dropdowns - All Chart Types - Template - click the template you created

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: I need to create a template that will dictate the thickness of chart lines

    See this previous post about pivot charts and templates.
    http://www.excelforum.com/excel-2007...rt-styles.html
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: I need to create a template that will dictate the thickness of chart lines

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    YOU DON@T NEED UNNECESSARY WORDING LIKE "I NEED..."
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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