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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Depends what you mean by "displayed". The values? The labels? Post back with more info about your problem...

Paddy
 

karraj

Board Regular
Joined
Mar 5, 2002
Messages
76
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
 

karraj

Board Regular
Joined
Mar 5, 2002
Messages
76
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
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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
 

Forum statistics

Threads
1,144,312
Messages
5,723,654
Members
422,508
Latest member
Lordkit1

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
Top