How do I change the scaling in Excel Radar charts.

G

Gastec

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!!!
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Colors/Scale in Radar Charts 1
How do I a rotate my square radar chart (square->diamond)? 4
How to use color from a datasheet to be applied to same series on 1
How do I change x-axis in an Excel Radar Chart? 1
Set uniform scaling for same type of Pivot charts with varying dat 1
x-axis scaling 4
Scale setting in radar charts 2
how do i use excel to calculate weight (as in stone and lbs)? 6

Top