+ Reply to Thread
Results 1 to 5 of 5

Chart Lengend to show marker style on hidden line - Line chart

  1. #1
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,731

    Chart Lengend to show marker style on hidden line - Line chart

    I have formated a Stacked Barchart and on one data series - cahnged to a line , formated the marker to the size of the bar and set to not show the line

    the problem is the bar data series legend is correct style for the 3d effects etc
    however the line marker is the same style - but its only showing the line and not the style ?

    any ideas

    thanks
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Chart Lengend to show marker style on hidden line - Line chart

    Could you post an example? (IMO, 3D should be avoided on charts at all costs)
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,731

    Re: Chart Lengend to show marker style on hidden line - Line chart

    Hi, sorry for the delay,
    your right , i picked this up from someone who is leaving in a few weeks and I'm now changing all the graphs to NONE 3D
    however, I will still be using a line graph as a Bar graph

    i have attached an example

    the Target - is where I have used a Line Graph and just shown the Marker to make a bar

    if all the 3D is removed , which i'm doing tomorrow morning - it will still show a line and not a block in the legend

    any ideas - thanks
    Attached Files Attached Files

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Chart Lengend to show marker style on hidden line - Line chart

    Assuming you are referring to the Target series, there are two of those. The one displayed in the Legend (the other has had its legend entry removed) is not the one you have formatted as you describe. If you delete the legend and reinstate it, you should see what I mean.

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,731

    Re: Chart Lengend to show marker style on hidden line - Line chart

    oh wow - that was easy, excellent - thanks very much for doing that

    I guess I kept the legends for the main primary series and because the secondary series is just one data element it appears to pick up the marker

    great all solved

+ 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. [SOLVED] How do I move a line marker on a line column combination chart?
    By dknj30 in forum Excel General
    Replies: 7
    Last Post: 05-08-2012, 09:21 AM
  2. Chart. Marker line length. How to change
    By Richard Buttrey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2010, 05:02 AM
  3. How to create single marker on the line chart?
    By nelsonys in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 07-28-2009, 08:50 AM
  4. [SOLVED] How can I add a line chart in a stacked column chart style?
    By Guilherme Loretti in forum Excel General
    Replies: 0
    Last Post: 08-02-2006, 08:50 PM
  5. Arrow on a line chart as a marker
    By sbigelow in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-09-2005, 11:05 PM

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