#### Power2006

##### New Member
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

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Just set the data up right & plot that?

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

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.

Replies
3
Views
201
Replies
4
Views
253
Replies
1
Views
158
Replies
1
Views
117
Replies
10
Views
905

1,219,998
Messages
6,151,378
Members
451,023
Latest member
dwalc

### 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.

### Which adblocker are you using?

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

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