Problem with a chart

peterv

New Member
Joined
Dec 6, 2004
Messages
18
I have been running a survey at work that had 4 possible answers or was left blank for some statements.

I have got the results in a bar chart that shows the percentages of the 4 possible answers for each of the statements. What I want to do is show on the right hand side of the chart the total number of responses received for that particular statement.

I have tried using the secondary axis function but this does not work.

Any thoughts would be appreciated

:confused:
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Kelbo

Board Regular
Joined
Jun 16, 2007
Messages
224
I think this idea is what may help you.

With your data you nedd three sets of information.
1. Reference to the questions
2. Total replies for each question
3. Percentage of total for each question

Select these three sets of data.

Select chart wizard.

Select Custom types.

Select 'Tubes' (on my system last type)

You can add more information in the usual way.

When you have produced the chart you can move the labels and colour to suit.

Hope this solves the problem
 

peterv

New Member
Joined
Dec 6, 2004
Messages
18
Thank you for the reply.

I have had a look at your suggestion. and on trying it it replicates the bar chart I am using.

Whilst this produces part of the answer I need, I cannot work out how to put the total number of responses alongside each statement. (Preferably to the right of the Chart).

Unfortunately I can not post a sample as my network admin security systems prevent it.
 

Kelbo

Board Regular
Joined
Jun 16, 2007
Messages
224
I have done a similar chart where it showed the number of responses in the first part of the bar and the percentage at the end.

Both pieces of data were written verticallyand the alignment had to be modified.

The position of the data can be moved to suit.

Alternatively
Select cells to graph as before
(This should give 3 rows selected)

Select chart wizard - Bar Chart
Select next and add, under titles, Category X axis 'Question'
Category Y axis 'Responses'
Then Finish
You should have a graph with two sets of data.

Right Click on one of the percentage bars
Select Format Data Series
Select tab for Axis
Select secondary axis
Click OK

Right Click on Chart Area and select Chart Options
Value Y axis enter Number Responses
Second Value Y axis enter Percentages

This should give the type of chart you are looking for!!
 

Watch MrExcel Video

Forum statistics

Threads
1,126,986
Messages
5,621,990
Members
415,872
Latest member
ReignEternal

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top