CHART: multiple vertical AND horizontal line in one chart?

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

itr674

Well-known Member
Joined
Apr 10, 2002
Messages
1,778
well been messing with this for about an hour and can't seem to get a vertical and horizontal line in the same chart. And having some problem with vertical line when uisng months and year only and not days like the example shows??

I'm trying to show milestones with the horizontal line representing the number of tasks required to complete and the vertical line showing the month when everything must be completed. A line chart will show how many tasks have been completed each month so we can see how things are moving along...
 

itr674

Well-known Member
Joined
Apr 10, 2002
Messages
1,778
eliW--here you go...
Book1
ABCDEFG
1Version1:singleHori&VertTargetsVersion2:multipleHori&VertTargets
2MonthNumberTrainingItemsCompleteMonthNumberTrainingItemsComplete
3Oct-062Oct-062
4Nov-064Nov-064
5Dec-066Dec-066
6Jan-079Jan-079
7Feb-0710Feb-0710
8Mar-0715Mar-0715
9Apr-0715Apr-0715
10May-0720May-0720
11Jun-0722Jun-0722
12Jul-0730Jul-0730
13Aug-0735Aug-0735
14Sep-0740Sep-0740
15Oct-0745Oct-0745
16
17(thiswouldbethehorizontalline)(thiswouldbethehorizontalline)
18Target45Target110
19Target220
20Target330
21(thiswouldbetheverticalline)Target445
22MilestoneDec-07
23(thiswouldbetheverticalline)
24Milestone1Dec-07
25Milestone2Mar-07
26Milestone3Jun-07
27Milestone4Sep-07
Sheet1
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,922
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

You can get any number of horizontal and vertical lines on the same chart, as long as you don't exceed 255 total series in the chart.

I can't tell from your data what the problem is exactly, but it might be that my example used days, so a date works well as the X values for any added XY charts. If you're using month and year categories, the dates are no longer in the same serial sequence as if they were days. You need to figure out what numerical values of X for the XY chart correspond to the months and years of your time scale axis. A hint, though. By day, the date is figured as the number of days since 1/1/1900. By month, October 2006 is the 1281st month since January 1900 (including January 1900). I just et up a quickie chart, and my XY point with X=1281 lines up with the line chart time scale axis at October 2006.
 

itr674

Well-known Member
Joined
Apr 10, 2002
Messages
1,778
Jon

Do you mean replace 11/9/02 with 1281 ??

Code:
    X	    Y

[blank]    Today	
1281         0	
11/9/02      1
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,922
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Do you mean replace 11/9/02 with 1281 ??

Didn't you try it? (You know how I learned about Excel? I read all I could find, and I tried everything. Sometimes I even tried before I read the answer, and if it didn't work, I tried other things, then I read the answer, and tried that. Pretty soon, I got good at knowing what the answer was going to be.)

When you tried it, didn't it work, or at least get you 99% of the way there?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,993
Messages
5,545,377
Members
410,679
Latest member
rolandbianco
Top