Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

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

Advertisements


#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






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP