If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
## Charts: (non-)fixed scale ##
Product: MS Excel 2002 (English version)
Table: Weight of parcel and its price Weight (kg) Price (=A3) 0 0 1 3.32 1.5 4.27 2 4.58 4 6.91 6 7.54 8 8.59 10 9.23 30 10.76 What I wish to do: Create a line chart for the above. However the chart I create is somewhat like below: {X-axis} [fixed scale] 12 11 10 .. .. .. 3 2 1 0 0 1 1.5 2... 10 30 {y-axis} [non-fixed scale] i. I would like to create a chart which both X-, Y-axis=20 is at fixed scale. The desired chart is somewhat like below: {X-axis} [fixed scale] 12 11 10 .. .. .. 3 2 1 0 0 1 2 3 4... 27 28 29 30 {y-axis} [fixed scale] Other Q: ii. How can I change X-axis or y-axis into fixed scale or=20 non-fixed scale? iii. How can I omit some values in X-axis or y-axis? Eg: I just wish to show values of "1-10", "25-30" in y- axis, others (ie "11-24") should be hidden. |
Thread Tools | |
Display Modes | |
|
|