• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 666
  • Last Modified:

Excel 2007 line graph

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.
1 Solution
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

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
bergquistcompanyAuthor Commented:

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now