How do I bring a certain data series to the front

G

Guest

I currently have a line graph set up with 4 data series--current info, 1
month ago, prior FYE, and 1 year ago. In the legend, the data series are
reverse chronological from left to right. I want the current info data
series on the line graph to show up on top instead of being buried by the
other series (some of the values are the same). Is there a way to bring this
series to the front without changing the series order under formatting?
 
A

Andy Pope

Hi,

The way to bring series to the front is to use the series order, but as
you realize this will change the legend order.
One way around this is to use another dummy data series which is a
repeat of the Current data. No need to duplicate it in the cells just
use the source data dialog to add another series. You can then remove
the repeat legend entry.
This explains how to delete legend entries.
http://www.andypope.info/charts/deletelegendentry.htm

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bring series to front 1
Chart SERIES OFFSET 3
Using a Cell Value to Adjust a Data Series for a Plot 2
Data disappears when I edit the chart. 1
How to change series plotting order without changing legend order? 6
How do I find the series associated with a given legend entry. 4
Re-Show chart data 1
How do i plot two series of data both in accending order on a line 1

Top