ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I change the scaling in Excel Radar charts. (https://www.excelbanter.com/charts-charting-excel/119896-how-do-i-change-scaling-excel-radar-charts.html)

Gastec

How do I change the scaling in Excel Radar charts.
 
I am using the Radar chart to build a circular chart that is recording 2
pressure ranges and one temperature range. My problem is the wizard builds it
in 10 lbs increments and one of my pressures is around 2.5 lbs.
Is there a way to create it in smaller increments ( 2 or 5 lbs)?
Also can you change the pen colors?
Thanks for any help!!!


Andy Pope

How do I change the scaling in Excel Radar charts.
 
Hi,

You can change the Major Unit value on the scale tab of the format
dialog for the Axis.

Double click the values axis to display the dialog.

To change a lines colour double click the series to display it's format
dialog.

If you are having trouble with clicking items you and use the up/down
cursor key to move through the charts elements. Or display the charting
toolbar, which has a dropdown of the chart elements.

Cheers
Andy

Gastec wrote:
I am using the Radar chart to build a circular chart that is recording 2
pressure ranges and one temperature range. My problem is the wizard builds it
in 10 lbs increments and one of my pressures is around 2.5 lbs.
Is there a way to create it in smaller increments ( 2 or 5 lbs)?
Also can you change the pen colors?
Thanks for any help!!!



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

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