different x axis lables

  • Thread starter Thread starter Bri
  • Start date Start date
B

Bri

OK, I will attempt to draw my chart here in ASCII...


I want to chart survey responses. I have calculated average responses. I am
thinking horizontal bar chart but will consider other options


Q1Negative ------------- Q1Positive
Q2Negative -------- Q2Positive
Q3Negative --- Q3Positive
Q4Negative ----------- Q4Positive
1 2 3 4 5 6 7

what would also be nice is

Q1Negative 1 2 (3) 4 5 6 7 Q1Positive
Q2Negative 1 2 3 4 (5) 6 7 Q2Positive
Q3Negative 1 (2) 3 4 5 6 7 Q3Positive
Q4Negative 1 2 (3) 4 5 6 7 Q4Positive

With the first horizontal bar chat example I can get the bars, the y axis
and the left hand x-axes lables, If I could just add the right hand lables I
would be golden.

Any help will truly be appreciated. And of course I am up against a
deadline.
 
Excel 2002, the data is originating in a database (not that that matters)
but I have complete flexibility on DB output to support the chart.
 
Also, where I have labels in my examples such as Q1negative and Q3Positive,
etc, they will be actually questions.

For example, the survey would ask something like
How would you rate your organization on a scale of 1 - 7.

Poorly Managed 1 2 3 4 5 6 7 Excellently managed

Silly example but you should get the point.
 
Bri -

You can use a technique like one of these to put labels on the side of
the bar chart:

http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Your second approach could be done within the worksheet. Labels in
columns A and H, numbers in between. Put the actual values over in
column J, and use conditional formatting to highlight the closest number
in the grid. Select the grid of numbers, select Conditional Formatting
from the Format menu. Choose the Formula Is from the Condition 1
dropdown, and enter this formula:

=AND($J7<=B7+0.5,$J7>B7-0.5)

(I started in row 7). Choose an appropriate format for the cells that
meet this condition.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top