Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

tramlines

ResolvedVersion 2010

Tramlines

Question on charts & charting. How do you add tram lines to an excel chart? do you need to calculate before including in the chart?

Regards

Mark

RE: Tramlines

Hi Mark,


Thank you for the forum question.


Sorry there is no smart way of doing it. Well I couldn't find a smart way.

I have attached a workbook with a solution but I am sorry not the best.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Attached files...

chart ex.xlsx

RE: Tramlines

Hi Jens

I am unable to see the attachment, do you know the best way to access it?

Regards

Mark

RE: Tramlines

Hi Mark,

Sometimes it takes a little time before you can see it, but if you refresh the site when you look at my answer you should be able to see it below my signature.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Move to edge of data block

When data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.7 secs.