+ Reply to Thread
Results 1 to 3 of 3

highlighting one line in a diagram

  1. #1
    Registered User
    Join Date
    01-19-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2016 Office 365
    Posts
    25

    highlighting one line in a diagram

    Hi,
    I have a small but intriguing issue with a diagram. It's a simple diagram as shown below.
    The thing is, I would like to show how all the staples relate to the line marking 11% and 50 %. That is, I would like to highlight those lines in the diagram, and preferrably colour them in the blue and red respectively. Is that possible?

    ss.jpg

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: highlighting one line in a diagram

    Hi Nils

    If you add this to your graph data - i.e. you will now have 4 lines of graph data, the two you already have plus one that shows 11% in every cell and one that shows 50% in every cell - you can then right click on the extra columns and click 'Change series chart type' and select a line graph.

    I hope that makes sense!

  3. #3
    Registered User
    Join Date
    01-19-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2016 Office 365
    Posts
    25

    Re: highlighting one line in a diagram

    Thanks, that works perfectly!

+ 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] Trend line on a stacked bar diagram.
    By siggisigg in forum Excel Charting & Pivots
    Replies: 28
    Last Post: 05-16-2020, 08:17 AM
  2. [SOLVED] Excel Diagram: bubble diagram with dynamic quadrants
    By meiselsan in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-27-2015, 08:26 AM
  3. problem in line diagram- Messy line diagram
    By meus in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-16-2014, 12:50 AM
  4. [SOLVED] in Column diagram i want to have a horizontal line on a specific place
    By guidom in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-13-2014, 04:49 AM
  5. [SOLVED] create line diagram
    By frhling in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2012, 09:43 AM
  6. [SOLVED] Highlighting of a Line with an Input
    By donald3030 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-16-2012, 06:55 PM
  7. Simple One Line Diagram
    By Retrop in forum Excel General
    Replies: 2
    Last Post: 03-08-2011, 05:06 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