Software

Ask something
Discussion Locked

excel chart

0 helpful
6 replies

by support person

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Want to create a chart with two vertical axis. Left axis would represent percentages and right axis would represent numbers. Horizontal axis would represent Status': i.s Status 1, Status 2, etc.

For each status I wish to create two vertical columns-one referring to the left axis(percentages) and one referring to the right axis (numbers).

Have not been able to get excel to create this. Any ideas?
Thanks, Jeff

6 replies

by el flush san

You need to check your layout. I've done a quick simple test.

Type in Status 1 - 5 running down in column A
Type in Numbers in column B
Type (or calculate) Percentages in column C

Select all three and you should have the two vertical axis against a single status horizontal.

by support person

thanks for responding. the basic problem is that i cannot get it to create two columns for each Status (one column for percentages and the other column for numbers. for example, it creats a column for percentages and a line graph for the numbers andi cannot figure out how to convert the line graph to a column.
thanks

by sankulpune

Hello support person,

Place the range you want to appear at x axis ('Status') in the leftmost column and the other two ranges ('numbers and percentages')in the right column of this range.
Format all the values in the left column (x axis) as labels by prefixing them with '.

1) Select the data range and click 'Insert > Chart' to launch the 'Chart Wizard'.
2) Select the bar chart in the step 1 ('Chart Type') of the wizard
3) In the next step (step 2 - Chart Source data) the range will beautomatically selected. Ensure that 'Columns' radio-button is checked in 'Series In'.
4) In 'step 3 - Chart Options', Check 'Primary axis, Category (x) axis, Automatic' and 'Value (Y) axis in the 'Axes' tab.
5) Select appropriate option in 'Step 4- Chart location' and click finish.

You will see a chart with values in left column ('Status') on x axis and bars for other values in the other two columns('numbers and percentages').

I would be glad to help you if you need more information in this regard.

With best regards,

SanganakSakha,
Your Friend In Need.

This discussion is closed to new replies.