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)
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,772
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,605
Messages
5,832,677
Members
430,153
Latest member
Javid_P

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