Jump to content


Create Account Login to Account

EXCEL - Produce bar graph with a line


  • Please log in to reply

#1
tiroshii

tiroshii

    Member

  • Member
  • PipPipPip
  • 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

  • Untitled-1.jpg

  • 0

Advertisement


#2
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 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
  • 0

#3
Vino Rosso

Vino Rosso

    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
  • 0

Advertisement





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured
Malware Removal How to Guides Windows 7 System Building Download Files Register welcome

Never used a forum? Learn how.