specify a values for (x) axis in bar chart

[Maryam]

how can i specify a values for (x) axis in bar chart in
Excel ?? My (y) axis is percent and i need to change the
width of bar on (x) axis, but it seems that i can just
change the category of it.


my project is that for example from 10 to 90m we have
20%, 30% and 50% of three material, from 90 to 200m we
have 10% and 90% of two material, etc. I also welcome
other suggessions to show this on table.

 

[Tushar Mehta]

The only 2 charts in the XL domain that allow values for the x-axis are
XY Scatter charts and Bubble charts. For other charts, if and only if
the x-values are dates, one can set the x-axis to 'Time scale' to get
spacing that is dependent on the x-values. For everything else, the x-
axis is a category axis in that successive items are always adjacent to
each other.

Some effects can be simulated. How are your data values organized and
how do you want them plotted?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Maryam -

Something about your description made me think of this example:

http://peltiertech.com/Excel/Charts/SqueezeColumns.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______