microsoft-excel-training - two data series one
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777
STL

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-training - Two data series on one bar graph

microsoft-excel-training - Two data series on one bar graph

resolvedResolved · Low Priority · Version Standard

Mon 14 Jan 2008, 10:59 replyReply Delegate Paru said...

Paru has attended:
Excel Advanced course
Access Introduction course

Two data series on one bar graph

Dear Sir/Madam,

Please could you help me on the following excel graph problem i have:

ok im trying to put two sets on data onto one bar chart. i cant get the graph to put the data on two different axis, even though i only have one set of legends labels.

i hope this makes sense.

please help

Many thanks in advance
Paru

For upcoming training course dates see: Pricing & availability

Mon 14 Jan 2008, 11:32 replyReply Trainer Richard said...

RE: Two data series on one bar graph

Hello Paru

Thank you for your question regarding usingin two data axes on a chart in Microsoft Excel. The way to do this is pretty simple.

When the values in a 2-D chart vary widely from data series to data series in a 2-D chart, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated data series.

On the chart, click the data series that you want to plot along a secondary value axis.
On the Format menu, click Selected Data Series.
On the Axis tab, click Secondary axis.

I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Excel question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer


Mon 14 Jan 2008, 11:41 replyReply Delegate Paru said...

RE: Two data series on one bar graph

Dear Richard,

Thanks for your email reply.

Im still a bit ( ok very) unclear.
do i create my first bar chart with one set of data first? than attempt to add another series - if so i cant do that.

or do i have to put all the data in one table than create a chart.

i cant select other data when i have charted a graph from one set of data.

Mon 14 Jan 2008, 11:59 replyReply Trainer Richard said...

RE: Two data series on one bar graph

Paru,

Please let me know if that clarifies it for you.

Thanks

Richard

Mon 14 Jan 2008, 11:32 Edited on Mon 14 Jan 2008, 11:58 replyReply Trainer Richard said...

RE: Two data series on one bar graph

Hello Paru

Add both series to the chart at the beginning of the chart.

Once you have both on the chart, then select the one you want to add the second axis for.

Regards,

Richard
Microsoft Office Specialist Trainer


Mon 14 Jan 2008, 12:09 replyReply Delegate Paru said...

RE: Two data series on one bar graph

ok that works.

thanks for all your help

Kindest Regards
Paru


 

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Training classes
London & UK

Live dates & prices »

On-site training

60-second quote »

E-Learning

From £99 · Call us »

Mailing list

Sign up for latest offers »

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.



Excel training
Course rating
4.7 stars - based on 24911 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom

info@microsofttraining.net

Resources