How do I change the scaling in Excel Radar charts.

G

Guest

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

How do I change x-axis in an Excel Radar Chart? 1
Excel change parameters in multiple charts 1
How do I change the source worksheet for 100 charts automatically. 1
How do I update charts in excel 2007 2
How do I change the color of the timeline boxes in my Ghant chart 1
Charts forget range or data; fixed by manual alteration then Undo 1
How do I use excel names with INDIRECT with charts 2
How can I update my charts x axis (dates) automatically with new d 1

Top