+ Reply to Thread
Results 1 to 2 of 2

Add 2 vertical lines to bar chart

  1. #1
    Registered User
    Join Date
    07-16-2008
    Location
    netherlands
    Posts
    3

    Add 2 vertical lines to bar chart

    Hi,

    I have created a simple bar chart with target prices on the x-axis and names of firms on the y-axis.

    I now want the following:
    (1) to add a vertical line showing the average price and another vertical lines showing the maximum price.
    (2) align the data labels in such a way that are aligned at the right side of the graph (they are now located just outside the bars)

    any help is much appreciated ...

    thanks very much in advance

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    Here is a link to peltiertech where he talks about adding lines to Column Charts. You'll have to extrapolate a bit for it to work on a bar chart.
    http://peltiertech.com/Excel/Charts/AddLine.html

    I used the ErrorBar method to make the chart attached. It's tricky but the results are good.

    ChemistB
    Attached Files Attached Files

+ 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