Home News Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | New video card or not?

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion
Reload this Page Excel Question ?
Register FAQ Community Calendar

Excel Question ?
Reply
 
Thread Tools
Old 19-01-2015, 13:24   #1
Mike
cf.mega poster
 
Join Date: Jan 2004
Age: 61
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Excel Question ?
Hi all

Hope someone can help please

Need to produce a bar chart showing delivery against time....(see attached)

Is it possible to show planned delivery above the line and actual delivery below line

Ie

A silpped 2 months
B is on target
C was delivered a month early.

Would apprecaite any help.

Many thanks for your time

Regards

Mike
Attached Files
File Type: pdf Excel Q.pdf (90.7 KB, 10 views)
Mike is offline   Reply With Quote
Advertisement
Old 19-01-2015, 18:47   #2
qasdfdsaq
cf.mega poster
 
Join Date: Aug 2004
Posts: 11,207
qasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronze
qasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronzeqasdfdsaq is cast in bronze
Re: Excel Question ?
Yes. You need to add two data series, and convert all the 'Actual delivery' values to negatives. Then put it in a bar chart and set the overlap to 100%.
qasdfdsaq is offline   Reply With Quote
Old 21-01-2015, 07:28   #3
Mike
cf.mega poster
 
Join Date: Jan 2004
Age: 61
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Re: Excel Question ?
Quote:
Originally Posted by qasdfdsaq View Post
Yes. You need to add two data series, and convert all the 'Actual delivery' values to negatives. Then put it in a bar chart and set the overlap to 100%.
Many thanks for the advice

Mike
Mike is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:36.

Contact Us - Service Status - Cable Forum - Archive - Privacy Statement - Terms of Service - Top

Server: osmium.zmnt.uk
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.

Copyright © 2024 Cable Forum Hosted On Hetzner Cloud