A line across my area chart
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. |
A line across my area chart
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? -- If this helps, please click the Yes button Cheers, Shane Devenshire "PapaJoe" wrote: 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. |
All times are GMT +1. The time now is 12:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com