specify a values for (x) axis in bar chart

  • Thread starter Thread starter Maryam
  • Start date Start date
M

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