A line across my area chart

[PapaJoe]

I use a spreadsheet to trend multiple elements by date. Auto-filter selects
which element is charted. Some of the graphs (I have 6 graphs, each with
multiple columns graphed versus x=date) are Area charts, and there is a line
between the first data point and the last data point that messes up the
shading of the areas such that below that line the included data is shaded
above the line but the excluded data is shaded below the line (hard to
describe without a picture).

Also the Excel 2007 auto-filter is magnitudes slower than previous Excel
versions and I cannot do the same quick-step process as I used to. I used to
click on the auto-filter arrow and use my arrow keys to toggle between filter
items (i.e. Toyota to Honda) and hit enter. Now there are a ton of
mouse-clicks to do the same thing that took only a second or two in older
versions.

 

[Shane Devenshire]

Hi,

Regarding the autofilter - 1. It is far more powerful in 2007 then in 2003
2. If you are applying autofilter to a range which is being plotted, the
plotting probably is the major reason things take longer - the graphics are
massively enhansed in 2007 but that results in far slower redraws - there are
published reports that Microsoft will issue a sp in the first half of 2009
which will impact the charting area (but how?)
3. You can use the keyboard to select items in 2007 - open the autofilter,
press the down arrow to reach select all, press Spacebar, press down arrow to
reach the item you want and press Spacebar. To toggle between already
selected Honda and an unselected item - down arrow to Honda, Spacebar, down
or up arrow to Toyota and Spacebar.

In 2003 select Honda, Toyota and Ford at the same time - pretty hard? Lots
and lots of mouse click. Try it in 2007. Open the autofilter over a date
field and pick Date Filters - try duplicating these choices in 2003. Under
Date Filters pick All Dates in Period and duplicate these in 2003. Filter on
Font Color, or Fill Color in 2003. Sort by Color in 2003. Try filtering on
Icon shapes in 2003. And I have just mentioned some of the new features in
2007.

Regarding the "there is a line between the first data point and the last
data point that messes up" I don't understand this one?