|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 3rd, 2006, 04:40 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
lower and upper chart
How can i create a worksheet with an upper and a lower chart? Like the
Bloomberg Charts. Upper chart with date, open, high, low and close. Lower chart with other indicator. Thanks 
|
|
#2
March 3rd, 2006, 04:49 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
lower and upper chart
Probably easiest to create 2 charts and align and format them to look like
one. See Stacked Charts http://www.tushar-mehta.com/excel/ne...rts/index.html -- Regards, Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach "pb" wrote: How can i create a worksheet with an upper and a lower chart? Like the Bloomberg Charts. Upper chart with date, open, high, low and close. Lower chart with other indicator. Thanks
|
|
#3
March 3rd, 2006, 08:38 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
lower and upper chart
That's easier, sure. But the alignment is difficult to maintain, as axis
labels increase or decrease in displayed digits and as other things change. I've had good luck with "layered" or "stacked" regions in a single chart. They may be harder to set up, but they are easier to keep aligned, because one axis fits the whole chart. Here's a simple example: http://peltiertech.com/Excel/Charts/StackedCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Tushar Mehta" wrote in message ... Probably easiest to create 2 charts and align and format them to look like one. See Stacked Charts http://www.tushar-mehta.com/excel/ne...rts/index.html -- Regards, Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach "pb" wrote: How can i create a worksheet with an upper and a lower chart? Like the Bloomberg Charts. Upper chart with date, open, high, low and close. Lower chart with other indicator. Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Changing file in all upper case to upper and lower case | Sagit | General Discussion | 15 | May 30th, 2007 06:08 AM |
| Can I join on both lower case and upper case in the primary key? | Bill@DS | Running & Setting Up Queries | 2 | December 19th, 2005 03:31 AM |
| List vector using upper and lower limits | flaterp | General Discussion | 6 | June 10th, 2005 11:17 PM |
| How do I distinguish between upper and lower case with pivot tabl. | Fielding | General Discussion | 1 | September 15th, 2004 01:00 PM |
| All UPPER CASE to Upper & Lower Case | DDM | Worksheet Functions | 1 | May 8th, 2004 09:04 PM |
Linear Mode
