Charts

Excel 2007 Stock market Charts
I teach a class in financial modeling. Some of my students use Excel 2003 and some 2007 (They are required to consult the company from whom they have accepted an offer and use the version of excel the company uses). In 2003 we generate a candlestick (Open High Low Close) Stock Chart for a company. We then add ... 1 May 2010 14:19

Bar width on existing chart changes when changing source data
Jon: Agreed! This fixed my problem as well. Thank you. Dan H. "Juli B" wrote: Jon - THANK YOU!! That also fixed the problem I had running 2 axes with a data table populated at the bottom... it kept wanting to force the data table into source order rather than the way it needed to be. Crazy!... 30 Apr 2010 15:10

Color gradient problem on X-Y chart
I used a top-to-bottom color gradient on an X-Y chart (formatted as a thick line, with no markers) – lower value line regions were red; middle values orange and high values, at top of chart, were green. It looked great… until it was opened on 2 other PCs (same OS & Office version), where the gradient is someho... 21 May 2010 11:43

chart to track product usage
Is there a way to produce a chart that displays different products (Y axis) against the dates they were used (x-axis)? An example would be: Product A used from 4-20-10 to 4-30-10 Product B used from 4-15-10 to 4-20-10 Product C used from 4-18-10 to 5-3-10 I want a chart with three parallel lines th... 30 Apr 2010 14:00

How can I convert numbers on an axis to text? Ex - 480 = Mon D; 7
Graph is based on shifts of 480 min each and 3 shifts per day. Graph covers 1 week. So I want to show 480, 960, etc. - which it does. But how can I also have 480 = Mon - D; 960 = Mon - A (D=days; A=afternoons). Thank you. ... 30 Apr 2010 10:36

How to add annotation/callout/note to chart?
In Excel 2003, is there any way to add an annotation/callout/note to a chart -- for example, if I want to add a description to a data point or other item? Thanks, Don Culp __________ Information from ESET Smart Security, version of virus signature database 5073 (20100429) __________ The message was ch... 30 Apr 2010 09:29

Overlapping bars within chart
Sample scenario: Let's say in each year, I have this many cats: 2010: 6 2011: 8 2012: 20 Out of those cats, let's say that the following number have been neutered: 2010: 1 2011: 4 2012: 18 Is there a way for me to create a form of bar chart that shows the total number of cats per year as a "background" b... 29 Apr 2010 20:22

Excel graphing and equation issues
Okay so here is my problem. For work, I have a curve that I need to put into excel and find the equation. So I look at the curve and record data points from the curve into excel. I will then graph the points and it will produce a curve just like the one have on paper. My problem comes when I ask excel to produc... 30 Apr 2010 09:29

Export Functionality is not working
Hello, I am using MS OWC 10 web component to draw chartspace on form. Export functionality of this component is not working. Please help. Sample code is given below. '---------------------------------------------------- Dim objChrtSpc as OWC10.chartspace set objChrtSpc = Form1.ChrtSpc 'Drawing the chart ... 29 Apr 2010 06:46

Why is my chart showing extra bullet points beyond 11 that I want
I have two questions: Why is my chart showing extra bullet points at zero beyond the 11 bullet points that I want? How do I get them off? I was going to chart two different things and they were labeled correctly, but the second one was not plotted correctly on the chart. The chart seemed to be adding the numb... 30 Apr 2010 09:29