Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I'm creating a fairly complex chart - a spider graph "dashboard" report that
addresses 4 major areas of an organization's performance - finance, quality, efficiency and customer satisfaction. Each category has 4-7 data elements, so that there are a total of 22 data elements on the chart. There will be 2 sections of the report, a chart showing YTD, LYTD and Goal values for the data elements and the graph itself. I envision this as a relatively easy way for management or board to get a snapshot of comparative key performance indicators. So far so good - input form, calculations, data chart and graph are all created and working properly, now it's a matter of presentation. Each major category is formatted to a different color on the data report - Financial = green, Quality = Red, Efficiency = Blue and Customer Satisfaction = Black. I would like to carry this formatting over to the graph so that the category labels are 4 different colors. I can change the format of the category labels, but I only see how to change them to one particular color, and I'd like 4 different colors. Any suggestions would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to colntrol location of category X axis labels on a bar chart? | Charts and Charting in Excel | |||
Category Labels(X) axis on a chart: | Excel Worksheet Functions | |||
Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel |