Good morning all
I'm working on a radar chart within Excel but not really sure what I'm doing but I know what I want to to achieve.
I have seen other radar charts coloured green on outside going into red in the middle, mine however does not do this.
For the result I'm looking for I have also enclosed a picture.
Would anyone be able to help, I probably haven't selected the right data for the chart to work.
My attempt attached as well.
Many thanks
Reverse rows and columns and it will work...
Please Login or Register to view this content.
Hi Zbor, how do you mean?
I can't make that work - @zbor can you provide a workbook showing this?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sure..
Here is the example.
I've used your data plus added one set of data (for future use) so you have two radar circles.
That's awesome, and having two radars is a good shout - I can certainly use that.
So what is the best way to colour the radar as the example?
Is that possible
With some playing I've managed relativly quickly to add radial colors.
They don't match the lines.. Maybe you can look around..
Right click on the chart (on the chart.. if you make right click on the lines you'll edit lines).
Format plot area
Choose Fill -> Gradient fill and play with options...
(Type radial, Direction inside out, etc).
Untitled.jpg
Last edited by zbor; 04-23-2024 at 05:58 AM.
You can add multiple series and mix Filled radar and line radar.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks