creating a chart #2

Hello, I'm trying to create a chart that will mimic the candlestick chart but 
it does not use a timeline. Instead of displaying the timeline along the 
X-axis, it will show the thickness of the sheet.

Sample data available as follow :

1st data set:
Thickness: 0.010
Min: 10
Max: 15

2nd data set:
Thickness: 0.013
Min: 10
Max: 25

3rd data set:
Thickness: 0.025
Min: 15
Max: 35

The chart will display the "Thickness" along the X-axis and the "Soak Range" 
(Min and Max) along the Y-axis.

Microsoft Excel require several variable to create a stock chart, namely:

Open, High, Low, & Close

I have tried to mimic the candlestick chart by making the Y-axis (Soak range):

Both "Open" and "Low" have the same value as "Min"
Both "High" and "Close" have the same value as "Max"

I was successful in my attempt for the "Soak Range" but the Thickness value 
shown along the X-axis is incorrect. It will display the number "1" "2" "3" 
instead of "0.010" "0.013" "0.025".

How can I correct this? I'm using MS Excel 2002.


Devin (29)
4/27/2005 11:50:01 PM
excel.charting 18370 articles. 0 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 49


Similar Artilces:

routing issue #2
we have two routers, one is attached to an ISA server which is used mainly for the internet one is attached to the exchange server which is used solely for email the exchange server is sending mail throo the ISA router server - how can i make it use the exchange router ? - the IP of the ISA router is showing in the email headers mark Hi, I presume the default gateway of the Exchange server is the ISA router? Therefore it will always route through it. This is all theory, as I haven't got the time to test it at the moment: Add another IP to your Exchange server, which DFG is the r...

chart area line missing in one pace (with picture) Can anyone tell me why there's a piece of line in the chart area border missing? I checked, and there is no object floating over it. Thanks. If you change the size of the chart area, does the missing postion stay the same? if you change the backgrond color of the chart, what do you see? If you move the chart area in the chart doc, what do you see? If you regenerate the chart what do you get? In other words, I don't know what causes it. "Dave R." wrote: > > > Can anyone...

Create a list with multiple criteria
I have a data base with 1,000's of addresses w/zipcodes (Sheet 1 columns A to E, E being zipcodes). After setting a base address I get all of the zipcodes within a given radius (in this case 70 zipcodes), listed in Sheet 2, Column A. Next, I use COUNTIF (in column B) to find how many addresses are in each zipcode, in this example there are 46 addresses within the 70 zipcodes. What I want to do is create a list in sheet three that will list each with the data from Sheet 1 columns A to E). Any help would be appreciated. Ronbo ...

Deactivating an embedded chart
Is it possible to deactivate an embedded chart (chart in a worksheet, not a chartsheet). I have an embedded chart that has a large data source range (about 10,000 cells) and a VBA macro that performs some calculations and inputs the results into these cells, but the chart updates in realtime and it slows the macro down quite a lot. I have read that the following code could be used if the chart is in its own chartsheet: Code: -------------------- Private Sub Chart_Deactivate -------------------- But my chart is embedded, so how could I deactivate/reactivate it? Alternatively, I though...

Symbols in Excel 2007 Chart
Dear Group, Hello. I would like to use the greek mu symbol in an Excel 2007 histogram. I am able to convert the "m" into the proper "mu" symbol in the spreadsheet itself but this is not reflected in the resulting graphic. I need for my X axis label to be represented by the proper greek letter, not m. Does anyone know how to fix this issue? Thank you in advance. John McLaughlin In many fonts, holding Alt while typing 0181 on the numeric keypad produces �. This means you don't have to change the font for some of the characters in a text element (and many tex...

Combining multiple Stacked Charts
I have 3 scenarios with info on Asset A and Asset B for 10 years. I can create stack charts for each scenario independently, but can not figure out how to combine all 3 onto 1 chart across multiple years. x axis is year and each year should have 3 stacked lines Y Axis should be total value of both Assets Any help appreciated Does this help? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - _______ "JANeyer" <...

=?iso-8859-1?Q?=22microsoft_office_document_imaging=22_documents=3F?= #2
Is there a program available for Mac that can read "microsoft office document imaging" documents? I have a number of email attachements sent to me with "filename.mdi" that I need to open Can they be opened on a Mac running OS X? ...

Cascading Combo for Chart Source
I have found some examples of how to use a combo to set the data source of an excel chart (see, using a combo to set an offset. In this case I'd have a combo box of counties which return number which is used as the offset. The relevant row is then used as the source for the chart. COUNTY WEEK01 WEEK02 WEEK03 WEEK04 Staffordshire 1.1 1.2 1.4 2.1 Derbysire 2.1 3.3 4.1 2.2 .... However, I have another spreadsheet that has the monitoring stations within counties. There are hundreds so it wouldn'...

Move a single org chart shape
This is a simple question (I hope). I am trying to reduce the vertical space between the shapes at the top of my organizational chart. If I try to move or nudge any one of these shapes, all of the shapes below it also move thus making it impossible to close the gap. If I try using the "change spacing" feature, it rearranges all of the shapes in my chart. Any advice would be greatley appreciated. Claudia The change spacing feature has several options, one of which is the Selected Shape. That should allow you to change the spacing for that shape only. So, i...

How to chart?
Need Help Charting Data -------------------------------------------------------------------------------- I have data in the following format: 10-05-04 395032 33757864 10-05-04 394656 33757864 10-05-04 394704 33757664 10-05-04 385544 33740816 10-05-04 431360 33795440 10-05-04 419656 33798832 10-05-04 403472 33768480 10-05-04 447864 33843624 ...

Cannot create new mailbox
I'm having an issue of not being able to create a new mailbox. I can go through the process of creating the user in AD Users & Computers and everything is successfull. I can even see the user in the GAL. But I cannot access the mailbox by opening it nor does it show up in system manager even after sending a message to the mailbox. I do have full permissions to the mailbox. It seems like it is not being created even though the recipient policy seems to be working because it does generate an address for the account. Any help would be appreciated. ...

how to insert chart for imported data in a report?
plz reply soon if you know Please use the large white space under the subject to enter a detailed question. It also helps to read some past threads that might pertain to your question (whatever it is). -- Duane Hookom Microsoft Access MVP "varsha from pilibhit" wrote: > plz reply soon if you know ...

how do i create a macro to export a chart to powerpoint?
Can anyone give me any tips to create a macro to export data to powerpoint. When I try to record the sequence it falls over at the 'copy' stage. Hi, Have you seen Jon's page on the subject? Cheers Andy -- Andy Pope, Microsoft MVP - Excel "NPAT" <> wrote in message > Can anyone give me any tips to create a macro to export data to > powerpoint. > When I try to record the sequence it falls over at ...

Error created when try to Print Preview or Print
When try to print or print preview system is generating an error: "Print titles must be contiguous and complete rows or columns." Used excel for years ever seen this error before. Using Excel 2007 on Vista, we just upgraded to SP2 for both systems. After testing a few times, I notice that system is generating a Name Range with no referencing cell range, the name range is called Print_Titles. If I delete the name range it removes the error message and able to use print preview and able to print. Notice it is occurring more ofter when client is copying a worksheet to ...

Creating Excel Invoice Template
I have been trying to customize a downloaded template but was frustrated so trying to create my own invoice. My question is once I input the formulas how do I keep/save them ???? when I enter the first calcualtions all is well, but if I go back and edit in the cell where the formula resides I lose the formula ??? I am a relative newbie to this so any help will be greatly appreciated. I have searched this site and cannot find a link to creating an invoice worksheet. Sasha ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions wit...

Making charts equivalent
We track the average patient value on a number of different analytes. Is there a standard way to make the graphs appear equivalent? If I track hemoglobin with a mean of 14.0 with the minimum set at 10 and the max set at 18, and then I have a second graph for hematocrit that has a mean of 38, but the max is set at 41 and the min at 35, the latter is a steep graph, and the former is flat, even though the hemoglobin values are approximately 1.3 the hematocrit. But the setting of the axis values can potentially make data look misleading. I am looking for a rule so that data will appear consist...

Date format problem #2
Dear All, Please suggest me the solution of my problem, as i m handling data for 60,000 in no.Some body in data entry has enter the date in a cell in gernal format e.g 20.03.2003 tht is 20th march 2003, i wnt to convert in the date fomat,like 3/20/03.. i tried ..but i failed to tht please suggest some alternative solution for tht..becoz it is not possible to do it mannually waiting for the response Thanks NISHANT Nishant Try using Data/Text to Columns. and assign the information as a date. Andy. "Nishant" <> wrote in message news:090201c37ce0$1b...

Pivot table sorting #2
Hello, I have a pivot table report for partnumber and values. This report is based on a database containing details like partnumber source import flag Description total value... etc. In my report i would like to sort the table in descending order of total value. I have tried advanced option by double clicking the total value field and changing the autosorting option to descending(total). But i am not getting the required result. My version of excel is Microsoft office excel 2003. Pivot table report is given below Source (All) Imp (All) Sub (All) Description (All) ...

convert time into decimal #2
=IF(E44="","X",E40-E44) the formula above where E40 is the time now, and E44 is the time of 2 hours ago. I want to return 2 instead of 2:00 PM. How do I do this? I do this but it does not work (E40-E44)*24. ...

comapring 2 seperate workbook
HELP!!! Is there any way you can compare 2 workbooks. for example, would be looking for a match (of values) from single columb o workbook 'a' to values of single columb from workbook 'b'. When eve there is a match between these two, maybe I can write it on ne workbook?(automatically). Or if there is any other tricks, please le me know. (I am sick of comparing it maually and when there is a match I am cutting and pasting to new workbook) -- Message posted from Hi as a starting point have a look at:

CRM 1.2 SBS 2003 Can not install exchange email router
Logged on as domain admin throughout. Installed CRM successfully, followed install instructions, did not install to local host installed web to a hostheader of "companyweb" port 80. during Exchange email router setup I get an error when specifying CRM server and web - "one or more os the MS CRM servers you listed is invalid or you do not have administrator priveleges on that server...." server name: sbssrb01 web http://companyweb If I go into IIS can not open CRM web get - http Error 403 - Forbidden: Access is denied. All services are on 1 server "sbssrv01&qu...

Chart not to pull Zero's
I am working on an Excel Chart that has future months showing with a Zero dollar value and it is charting the future months on my chart. Is there a way to get it so that the Zero's will not show up? I have a formula that is pulling the amount from another chart. Thank you for your help. Change "" to NA() in your formula. This puts #N/A into the cells, which is unattractive in the worksheet, but which is not plotted on a line or XY chart. =IF(A1=0,NA(),A1) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. __...

arrow keys #2
To move from cell to cell, I used my arrow and enter keys. They no longer work in Excel. I have to click on each cell to get there. Do you know how to fix it? Thanks. What happens when you use the arrow key? Check if your scroll lock is on or if you have something under tools>options>transition -- Regards, Peo Sjoblom "Shirley Smith" <> wrote in message news:079201c3af8e$fa3acc00$a001280a@phx.gbl... > To move from cell to cell, I used my arrow and enter > keys. They no longer work in Excel. I have to click on > eac...

How do I create a B&B reservation system in Excel?
Trying to create a reservation system for 6 room B&B in excel. Does anyone have template or know where to get one? ...

pie charts #9
How do I surpress the numbers from showing on a pie chart and just show labels? Select the pie, not the whole chart, and right click it, select Format Data Series ..., Data Labels tab, and select from there. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sara" <> wrote in message > How do I surpress the numbers from showing on a pie chart and just show > labels? ...