graph cost data below

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Graph with cost data below

Graph with cost data below

resolvedResolved · High Priority · Version 2007

Graham has attended:
Project Intro Intermediate course

Graph with cost data below

I am trying to create a graph based on "number of project" per month with the costs below the dates on the X axis.

I am using excel 2007 and it only allows me to make standard graphs / histograms

RE: graph with cost data below

Hi Graham

Thanks for getting in touch. What you're asking should be possible, though you are trying to plot three series:

1. Number of projects
2. Date
3. Cost

A simple chart will allow you to work with two series. If you want to plot a third you'll need to add a secondary axis, or by using a bubble chart.

Can you elaborate or link to an example online of what you're after?

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: graph with cost data below

Hello Graham,

Thank you for your question. Would it be possible to email me a sample spreadsheet containing the data and possibly a chart you have made, so that I can have a look at it. My email address is marius@stl-training.co.uk.

Kind regards,
Marius Barnard
Best STL


 

Excel tip:

Date and time

CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

View all Excel hints and tips


Server loaded in 0.07 secs.