Charts

[huorsa]

I create several stock charts using excel 2007, I include in the chart the "moving average", after I include it in the chart the information is "compressed" meaning that the information in the X axis (20 columns) is compressed and in a few columns (3 columns) so you can not read the chart.

But if I open that chart in another computer that has excel 2010 it looks fine.

Does anyone know what is goping on?

 

[smiler]

can you grab screen shots and post - see sticky threads on how to do this

 

[cyrilbrd]

Hi,

is the axis range the same on both 2007 and 2010 versions? based on what you described it sounds like the chart is truncated to fit the axis range.

 

[huorsa]

This is the information for the chart, the type of the chart is a stock chart. I was not able to insert it in the post using the add in. Just the information for the chart was paste it but not the chart.

As i explained I open the file in one computer using excel 2007 and it does not look good, I mean you can not read the chart. The I close the file and open it in a different computer with excel 2010 and everything look fine.

I do not know what is happening.

Excel 2007
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Open	High	Low	Close	Volume
2	04/01/2010	15.60	16.16	15.60	15.75	19792800
3	11/01/2010	15.84	15.91	14.85	14.99	17799000
4	18/01/2010	14.98	15.18	13.65	13.75	16499300
5	25/01/2010	14.01	14.08	11.92	12.02	58510800
6	02/02/2010	12.55	12.79	11.72	12.36	35426600
7	08/02/2010	12.38	12.85	12.14	12.35	21404200
8	15/02/2010	12.30	12.75	12.15	12.50	15749800
9	22/02/2010	12.56	12.63	11.92	12.29	18928900
10	01/03/2010	12.27	13.00	12.27	12.87	25668800
11	08/03/2010	12.85	13.39	12.80	13.13	22816000
12	16/03/2010	13.05	13.64	13.00	13.41	21158500
13	22/03/2010	13.20	13.82	12.50	12.65	39897500
14	29/03/2010	12.64	13.02	12.60	12.69	23981800
15	05/04/2010	12.83	13.49	12.75	13.28	25663900
16	12/04/2010	13.20	13.35	12.93	13.02	19126200
17	19/04/2010	13.01	14.80	12.80	14.70	37496400
18	26/04/2010	14.74	15.30	14.08	14.69	46012400
19	03/05/2010	14.75	15.10	13.16	13.27	44628900
20	10/05/2010	14.11	14.66	13.81	13.95	37010000
21	17/05/2010	13.90	14.25	12.95	13.20	39545700
22	24/05/2010	13.22	14.40	12.86	14.36	45140000
23	31/05/2010	14.15	14.80	13.12	13.18	40173500
24	07/06/2010	13.31	13.91	13.06	13.91	29159000
25	14/06/2010	13.98	14.22	13.76	14.00	31744200
26	21/06/2010	14.10	14.31	13.08	13.24	35755700
27	28/06/2010	13.26	13.28	12.12	12.23	53936100
28	05/07/2010	12.38	12.62	12.00	12.34	26101100
29	12/07/2010	12.39	12.82	12.00	12.01	28049200
30	19/07/2010	12.16	12.70	11.98	12.52	30426500
CEMEXCPO.MX

 

[cyrilbrd]

Hi, I sadly do not have the answer for I do not have excel 2007. Hopefully Smiler or anyone else using 2007 will be able to help you. Just wondering. Could it be in a way related to the way the data is organized? Excel is quite strict when it comes to Stock chart's data presentation. Could it be that the order of the fields differs from 2007 to 2010? just a wild guess.
Sorry not to be able to help further.

 

[smiler]

can you detail how to create the stock chart using the data you have supplied, and which type of stock chart

(I dont use stock charts so dont know which data you are using, how its selected, how you addd your moving average etc

if i can replicate what you are doing i can see if i have the same problem

thanks