Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

EXCEL - Produce bar graph with a line

Started by tiroshii , Dec 12 2011 07:54 PM

Please log in to reply

#1
tiroshii

Posted 12 December 2011 - 07:54 PM

Member

Member
423 posts

As title. I want to produce a graph from a table to look like the example attached. How can I do this?

Attached Thumbnails

#2
dm27

Posted 12 December 2011 - 09:46 PM

Member

Member
272 posts

Hi Tiroshii,

Depending on your data, you would graph them to the same chart. One will be formatted as a column chart on the primary axis and the second data set would be formatted as a line chart on the secondary axis...

Do you have some sample data we could test with?

Thanks,

dm

#3
Vino Rosso

Posted 13 December 2011 - 04:22 AM

Visiting Staff

Visiting Consultant
235 posts

One way is to create a column chart so all the data is shown in columns. Then right-click on the data you want to show as a line and select Change Series Chart Type... click Line > OK