Please help with Excel Charts

Power2006

New Member
Joined
Jan 17, 2006
Messages
29
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.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Power2006

New Member
Joined
Jan 17, 2006
Messages
29
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
ABCDEFGHIJKLMNOPQ
1Type12345678910111213141516
2Sales1,039,2931,065,999633,932506,978484,326565,647981,5151,275,5111,148,6851,069,961713,770606,559607,857744,4151,097,4011,144,706
3Cost1,242,116915,002854,950878,105903,785519,3161,000,0001,170,4021,283,163688,516650,919607,013673,810877,1161,108,1571,105,517
4Reductions70,23461,38263,62868,89569,47184,65874,64067,18464,161114,98285,34670,00370,11668,15375,02476,171
Data
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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.
 

Forum statistics

Threads
1,137,339
Messages
5,680,910
Members
419,940
Latest member
WilliamPorter

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top