Results 1 to 15 of 15

Formatting the y-axis of a chart

Threaded View

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

    Re: Formatting the y-axis of a chart

    Ah, the light just went on.

    See attached for the method mentioned by Andy applied to your chart

    A dummy series with X values of the lowest value on the X axis, combined with Y values of even distribution. The data markers sit on the Y axis. Use the XY Chart Labeler tool http://www.appspro.com/Utilities/ChartLabeler.htm for easy creation of labels for the data points to the left of the markers, then remove the axis labels.

    I've left the data markers for the dummy series visible, but you can set them to no markers to hide them.

    Just make sure that your primary and secondary Y axes have the same Min and Max settings.
    Attached Files Attached Files

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