LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Gklass
 
Posts: n/a
Default new time series chart type

The New York Times (the printed edition, I can't find it on line) new
uses a very interesting chart type to display stock price trends.

It shows the stock price trendline and straight lines from the base year
indicating +\- constant percentage changes.

They look something like this:
http://lilt.ilstu.edu/gmklass/poverty.gif
except:
The x axis is scaled so the the percentage change produces straight lines.
It includes several constant percentage change lines with the areas
shaded: a plus or minus five percent growth rate will be shaded dark, a
ten percent, shaded lighter.

If I spent all day, I image I could produce one of these, but I was
wondering if someone already had a macro that would do it.
--
Gary M. Klass
Associate Professor
Department of Politics and Government
Illinois State University
Normal, Illinois 61790
(309)438-7852

ISU\IWU Habitat Collegiate Home
<http://lilt.ilstu.edu/habitat/
SECA # 903 - 0234
 
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
Chart Series Not displayed Barb Reinhardt Charts and Charting in Excel 2 June 5th 06 10:55 AM
What Is The Name This Chart Type Minitman Charts and Charting in Excel 6 December 20th 05 05:55 AM
How to hide a dummy series in a chart legend? holg3r New Users to Excel 2 July 14th 05 09:04 AM
Can I add an average series to a chart with 2 or more series? Yaniv Charts and Charting in Excel 4 June 16th 05 11:37 PM
How to change Series Order in a Combination Chart? vrk1 Excel Discussion (Misc queries) 0 March 31st 05 11:19 PM


All times are GMT +1. The time now is 12:31 AM.

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

About Us

"It's about Microsoft Excel"