EXCEL - Produce bar graph with a line - Geeks to Go Forums

Jump to content

Log in Register Register Malware removal guide How it works

EXCEL - Produce bar graph with a line

#1 tiroshii

  • Group: Member
  • Posts: 422
  • Joined: 26-May 06

Posted 12 December 2011 - 07:54 PM

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

Attached thumbnail(s)

  • Attached Image: Untitled-1.jpg

#2 dm27

  • Group: Member
  • Posts: 266
  • Joined: 11-January 10

Posted 12 December 2011 - 09:46 PM

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

  • Group: Visiting Consultant
  • Posts: 235
  • Joined: 21-February 07

Posted 13 December 2011 - 04:22 AM

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

Share this topic:


Page 1 of 1