Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-20-2016, 03:39 PM
Italiano329 Italiano329 is offline Chart with Actuals and Goals for Multiple INTL Regions Windows Vista Chart with Actuals and Goals for Multiple INTL Regions Office 2010 32bit
Novice
Chart with Actuals and Goals for Multiple INTL Regions
 
Join Date: Sep 2014
Posts: 4
Italiano329 is on a distinguished road
Default Chart with Actuals and Goals for Multiple INTL Regions

Hello,

I am trying to build a chart that has the following as the X Axis: International / Atlantic / Pacific / Americas. For each region, I want to have 3 data sets - 2014 Actual, 2015 Actual, 2015 Goal. I would like 2014 Actual and 2015 Actual to be bars side by side, but the 2015 as a data point right above the 2015 Actual bar. I thought to start with all three as bars, and change the chart type of the 2015 Goal to a Line, but it places the data point between 2014 actual and 2015 Actual. Is there any way to change it so that the 2015 goal data point is directly above the 2015 Actual bar? I've attached my draft.

Really appreciate your help!!!
Attached Files
File Type: xlsx excel chart examples.xlsx (11.4 KB, 19 views)
Reply With Quote
 

Tags
bar chart, excel charts



Similar Threads
Thread Thread Starter Forum Replies Last Post
Showing Actuals on a Completed Task brymey Project 1 02-27-2015 04:21 AM
Strange behaviour when entering Actuals joday48 Project 4 01-15-2013 03:51 AM
Priority based levelling for split tasks having actuals proj12 Project 3 02-27-2012 06:47 AM
the best way to enter actuals ketanco Project 3 12-26-2011 09:36 AM
Chart with Actuals and Goals for Multiple INTL Regions actuals vs estimates projectman Project 23 11-15-2010 07:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft