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: 395
Default XL2007: stock chart- difficulty adding additional series

I have a chart where I need to show multiple range values. In 2007, I thought
that the stock chart would be the most useful starting point, where I could
use the Open/High/Low/Closing to represent standard deviations (high and low
at the 3stddev mark, and open/close at the 2stddev mark).

In order to make the chart useful, I need to add series (time series or
maybe scatterplot) to show specific values against those standard deviation
ranges. I'd think this would be useful on a stock chart too, because in
addition to seeing O/H/L/C you might want a data point on there showing the
price at which you bought (or sold).

However, every time I try to add a series, I get an error "some chart types
may not be combined". I'm usually a 2003 user, but hopped on a 2007 box just
in the hopes that 2007 would have a better default to build my chart(s).

Is there a better approach (other than building each series from scratch to
look like a stock chart), or is there a trick to adding series to the stock
plot? If I have to build from scratch anyway, I'll head back to 2003 to do so.

Thanks!
Keith
 
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
Formatting a 4 Series Stock Chart Patty Charts and Charting in Excel 0 November 24th 09 11:12 PM
Adding Additional Points to a Line Chart Christine Charts and Charting in Excel 7 September 21st 09 07:55 PM
Adding Horizontal Lines to a stock chart Bondonian Charts and Charting in Excel 3 December 21st 07 03:06 AM
Adding additional data to a pivot chart zasskar Charts and Charting in Excel 0 June 5th 06 09:23 PM
Adding a horizontal line to a stock chart wittmaennle Charts and Charting in Excel 3 April 21st 06 08:15 AM


All times are GMT +1. The time now is 12:43 PM.

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"