Skip to content

Excel – charting years

January 21, 2018

Have you ever had to create a chart or graph that dealt with years or some type of dates?  And it came out looking really strange.  An example is if you’re charting data that has years in it.  Excel often thinks the years are numbers – to fix this, type an apostrophe before the # and it becomes text and the graph will suddenly make sense!

This video demonstrates this feature.

Advertisements

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: