B
buke120
I want to draw a chart where I need to have both X-axis and Y-axis as
value axes. Excel always makes X-axis as category axis. Is there a
way to change it to value axis? Thanks for your help.
Just as an example: if use the following data to draw a line graph, I
want to get a straight line, which is possible only when I have both
axes as value axes:
X axis values: 1, 2, 4, 5, 8, 9, 10.
Y axis values: 2, 4, 8, 10, 16, 18, 20.
value axes. Excel always makes X-axis as category axis. Is there a
way to change it to value axis? Thanks for your help.
Just as an example: if use the following data to draw a line graph, I
want to get a straight line, which is possible only when I have both
axes as value axes:
X axis values: 1, 2, 4, 5, 8, 9, 10.
Y axis values: 2, 4, 8, 10, 16, 18, 20.