+ Reply to Thread
Results 1 to 5 of 5

Chart Formatting Across Data Series

  1. #1
    Registered User
    Join Date
    10-11-2020
    Location
    USA
    MS-Off Ver
    365
    Posts
    3

    Chart Formatting Across Data Series

    I am trying to copy all formatting from one chart series to another series in the same chart. All visible settings are the same, but the appearance is different. Specifically I have a stacked bar chart (vertical). The first data series has rounded tops, but the second series has square tops and is narrower than the first. I have no idea how I got the rounded tops on the first series, but that is what I want on the second as well so I was hoping I could just copy the formatting from series 1 to series 2. Any ideas on how to do that?

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

    Re: Chart Formatting Across Data Series

    See yellow banner above on how to upload example workbook.

    It's hard to say without seeing but it may be a 3d settings that is providing the round top, or another series with round markers
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-11-2020
    Location
    USA
    MS-Off Ver
    365
    Posts
    3

    Re: Chart Formatting Across Data Series

    Attached is an example of the chart. Note that the blue bar (mature) is the desired format.

    Thanks,
    Lance
    Attached Files Attached Files

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

    Re: Chart Formatting Across Data Series

    The blue bar has a thick border applied.

    To make the orange category the same you will need to add border, change colour and alter thickness to match blue series

  5. #5
    Registered User
    Join Date
    10-11-2020
    Location
    USA
    MS-Off Ver
    365
    Posts
    3

    Re: Chart Formatting Across Data Series

    Thank you! I knew I must be overlooking something simple. I greatly appreciate your help.
    Lance

+ 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. Replies: 2
    Last Post: 02-19-2017, 07:52 PM
  2. [SOLVED] Align Line Chart's data series Data labels on top of Bar chart data series
    By rgunlimited in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2014, 10:38 AM
  3. [SOLVED] Chart series formatting add-in
    By RitaB in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-19-2012, 11:52 AM
  4. Formatting Multiple Series in a Chart
    By jerseyguy1996 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2009, 09:22 AM
  5. Conditional Formatting of Data Series in a chart
    By joe90 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-27-2008, 06:17 AM
  6. [SOLVED] chart data series -- plot a table as a single series
    By hjc in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-20-2005, 01:05 PM
  7. [SOLVED] RE: Conditional formatting of a data series in an Excel Chart?
    By Rowan in forum Excel General
    Replies: 1
    Last Post: 07-29-2005, 09: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