Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts in Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Charts in Excel

Resolved · High Priority · Version 2007

Reply Fri 17 Dec 2010, 16:04Delegate Alan said...

Alan has attended:
Excel Advanced course

Charts in Excel

Why does line iN a line chart not start at left margin (y) but some way into graph?

For upcoming training course dates see: Pricing & availability

Reply Fri 17 Dec 2010, 16:36Trainer Stephen said...

RE: Charts in Excel

Hi Alan

Thanks for your question.

The line starts at the first data point ,which is positioned in the middle of the first category (X axis label). Thus there will be a gap. If you can give me more detail as to what you are trying to achieve, I can perhaps guide you further.

Regards

Stephen

Reply Mon 20 Dec 2010, 12:36Delegate Alan said...

RE: Charts in Excel

Thank you. I have an excel table to convert into a graph. It compares the baseline figure as it was at the end of September 2009 with the figures at the end of each subsequent quarter. The x axis is the quarters; the y axis is the quantity (actually the number of pages in documents issued). So there is one flat baseline and one rising and falling line. But I want both to begin at the left hand side of the table. If the data point is the problem, could I state it differently to get the desired result? I know that a previous team member was able to do this. If I could email you direct I could send an example.

Excel articles

· Excel 2010 A Glance Into The Future
· Simple Ways To Customise Excel
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· How To Share Files In Excel 2010
· Reasons Why VBA for Excel Training Fails

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips