Question on Line chart...how do I modify which metric is the line vs which is in the stacked bar?

Wheelzzz

Godzilla

the first series is always the line and the rest are bars. you control it using sorting. 

Unknown

Also note that you can set the number of lines (or symbols) that will appear in the chart. Go to chart properties > General and you'll see the open field that shows Number of Lines (or Symbols). If you have four series in your chart and you want two lines, then put 2 in the box, and place these two series first and second in your chart builder. 

 

This makes it much easier to manage secondary axes where you may have % and a large number on the other axis. 

Godzilla

the first series is always the line and the rest are bars. you control it using sorting. 

kshah008

@Wheelzzz, did Godzilla's reply help answer your question?

Unknown

Also note that you can set the number of lines (or symbols) that will appear in the chart. Go to chart properties > General and you'll see the open field that shows Number of Lines (or Symbols). If you have four series in your chart and you want two lines, then put 2 in the box, and place these two series first and second in your chart builder. 

 

This makes it much easier to manage secondary axes where you may have % and a large number on the other axis. 

Wheelzzz

Yes it did!  Thanks all!

mbelmont

This does not seem to be the case anymore and it appears the line is being arbitrarily chosen.  In fact, the line gets changed when I add a data label (what ?!?!)

 

Specifically, I have a series that is a count of certain string types so sorting does not work.  Is there anyway to choose which category is the line in this instance?