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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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,659
Messages
6,120,784
Members
448,992
Latest member
prabhuk279

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