Line Graphs in 2010

CMIIandExcel

Board Regular
Joined
Sep 4, 2009
Messages
190
Hi all

I am using a second y axis on a bar chart in 2010.
Y Axis one shows Bars and represents actual work done.
Y Axis two shows Lines and represents Target of 100 %.
the x axis is dates weekly

It all works fine, but the only problem is on the first and last week the lines start and stop in the middle of the date category (Column).

Is the a way to extend the lines so that they touch each edge of the graph (I.E from one Y axis to the other y axis)

I hope my definition is understandable

Regards

Mike
(New to 2010 and liking it)
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,067
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You can add a secondary X axis to the chart, format it with no line, tick marks or labels, and set it so the Y axis crosses between categories. Should do what you want, I think.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,576
Messages
5,596,965
Members
414,114
Latest member
Lost_User21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top