Jump to content

Free help from tech experts
Welcome to Geeks to Go forums. Create a FREE account now to gain access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing topics, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. Best of all, registration and all assistance is 100% free! This message, and all ads will be removed once you sign in.
Create an 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

Similar Topics: EXCEL - Produce bar graph with a line     x


#2
dm27

dm27

    Member

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


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured