ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel Charts (https://www.excelbanter.com/charts-charting-excel/217244-excel-charts.html)

Jim

Excel Charts
 
Hi, I use the chart function mainly to plot math graphs.
Is there a way of getting the Y axis to cross the x axis at an x value
rather than a catagory number?

Jon Peltier

Excel Charts
 
Use an XY chart instead of a line chart. Especially for mathematical charts.
An XY chart treats both X and Y as continuously variable values, while a
line chart treats the X values as non-numeric labels. You can format the
data points in either type of chart the same way, with or without markers,
with or without lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Jim" wrote in message
...
Hi, I use the chart function mainly to plot math graphs.
Is there a way of getting the Y axis to cross the x axis at an x value
rather than a catagory number?




Jim

Excel charts
 
Thanks for that Jon, much appreciated!


All times are GMT +1. The time now is 10:12 AM.

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