LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add line to a stacked area chart already created Mitch Charts and Charting in Excel 3 April 3rd 23 04:43 PM
Area Chart combined with Line Chart jmrd Charts and Charting in Excel 4 June 12th 07 07:01 PM
Slope line in stacked area chart jjbud44 Charts and Charting in Excel 3 May 15th 07 08:12 PM
How do I create an area and line combination chart? Nuala Charts and Charting in Excel 1 May 10th 06 09:28 AM
Area chart with smoothed line Gail Charts and Charting in Excel 2 November 14th 05 02:05 PM


All times are GMT +1. The time now is 07:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"