Please help with Excel Charts

[Power2006]

Someone please help me on excel charts. My X-axis is for example 0 - 50,000 in increments of 10,000. So that would be 0, 10000, 20000, 30000, 40000, & 50000. However for the 0 - 10000 I want to make that section bigger so I can view the graph better for that section, like change it to 0, 1000, 2000, 3000, etc. all the way to 10000. After that it will be 20000, 30000, 40000, & 50000. Hopefully I'm not confusing anyone. Thanks in advanced.

 

[Power2006]

Anyone?? Please help.

 

[PaddyD]

Just set the data up right & plot that?

 

[Power2006]

When you plot this notice, that reductions will be really low at the bottom. I just want to increase the y-axis just for the reductions section below so that i can see the flow of the graph better. Basically i want to find out as sales increase, does our reductions increase also, but since reductions is way lower than sales, i can't see how the graph really looks like, it just look like a straight line. thanks.

Last 4 wks and current POS and MDs.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Type	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16
2	Sales	1,039,293	1,065,999	633,932	506,978	484,326	565,647	981,515	1,275,511	1,148,685	1,069,961	713,770	606,559	607,857	744,415	1,097,401	1,144,706
3	Cost	1,242,116	915,002	854,950	878,105	903,785	519,316	1,000,000	1,170,402	1,283,163	688,516	650,919	607,013	673,810	877,116	1,108,157	1,105,517
4	Reductions	70,234	61,382	63,628	68,895	69,471	84,658	74,640	67,184	64,161	114,982	85,346	70,003	70,116	68,153	75,024	76,171
Data

 

[PaddyD]

just plot the three series on the same line chart, then right click on the reductions series, select format data series | axis & select plot on secondary axis.