Display all x values on the chart

karraj

Board Regular
Joined
Mar 5, 2002
Messages
76
Hi,
How can i make sure all my x values used to plot the graphs is displayed. the x values are not uniformly seperated.
Thanks,
Karraj.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Depends what you mean by "displayed". The values? The labels? Post back with more info about your problem...

Paddy
 
Upvote 0
I have a set of x and y values, I want to make sure i see the labels for these values on my graph. Unfortunately, the values are not evenly distributed.
Any way to make sure the labels are displayed as desired?
Thanks for your help.
Karraj
 
Upvote 0
xvalues yvalues
80 -2
83 5
85 3
89 7

By default, the x axis scale is 5 units.
I want to view all the x labels even if the x values change.
Karraj
 
Upvote 0
OK - still not clear on this? Is it just a matter that you've got so many data points you can't see all the x values? If so, (as far as I know) the limit on how many you'll see will depend on how the available space / number of points / font size for the axis combine. Got 10,000 point & you're not going to see all the axis labels...Or does your 'the x values are not uniformly seperated' remark indicate that you're also trying to get the x axis appropriately scales?

Paddy
 
Upvote 0

Forum statistics

Threads
1,214,962
Messages
6,122,482
Members
449,088
Latest member
Melvetica

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
Back
Top