ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I make the X-Axis increase in scale with the quantity? (https://www.excelbanter.com/charts-charting-excel/64388-how-do-i-make-x-axis-increase-scale-quantity.html)

Leif S

How do I make the X-Axis increase in scale with the quantity?
 
For example: If I have the values 1.5, 3.5, 8.7, 9.9 in the x values for a
line graph, is there anyway to make them spaced apart so that they are in
scale with eachother... Like so the distance between 3.5 and 8.7 is larger
than, the distance between 1.5 and 3.5?

Tushar Mehta

How do I make the X-Axis increase in scale with the quantity?
 
Create a XY Scatter chart. It, and a bubble chart, are the only 2 that
allow for cardinals values on the x axis.

--
Regards,

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

In article , =?Utf-
8?B?TGVpZiBT?= <Leif says...
For example: If I have the values 1.5, 3.5, 8.7, 9.9 in the x values for a
line graph, is there anyway to make them spaced apart so that they are in
scale with eachother... Like so the distance between 3.5 and 8.7 is larger
than, the distance between 1.5 and 3.5?



All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com