ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   select & format "single" axis line in charts (https://www.excelbanter.com/charts-charting-excel/72857-select-format-single-axis-line-charts.html)

Guru Guy

select & format "single" axis line in charts
 
Excel Charts: In the "Format Axis" window, (perhaps in the "Scale" tab)
allow users to define, select, and format single axis lines. This will allow
the user to display charts that have goals or % complete views.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Jon Peltier

select & format "single" axis line in charts
 
Do you want a single gridline? Excel doesn't offer this specifically, but
there are tricks one can use:

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

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

"Guru Guy" <Guru wrote in message
...
Excel Charts: In the "Format Axis" window, (perhaps in the "Scale" tab)
allow users to define, select, and format single axis lines. This will
allow
the user to display charts that have goals or % complete views.





All times are GMT +1. The time now is 04:08 PM.

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