Excel 2007 line graph

Posted on 2012-08-22
Last Modified: 2012-08-23
Hello EE,

I have an excel 2007 line graph reflecting price per inch.  My legend/key is least on top to greatest on bottom where my line graph has lowest price on the bottom and highest on top so the legend/key is inverted form the line graph.  I am wondering if that can be flipped.
Question by:bergquistcompany
    LVL 50

    Accepted Solution


    the sort order of the legend items is determined by the sort order of the data in the source table.  If you sort your data source differently, then the legend will reflect that.

    You can also use the "Select data" dialog and change the order of the series by selecting a series and clicking the up and down buttons.

    The series will by default take the same order as the source data, but you can change that order.

    See attached example.

    cheers, teylyn

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now