Board index » The Property Pin Website - Open Development » The Property Pin Website Open Development Forum

Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Best font for charts?
PostPosted: Thu Feb 25, 2016 11:18 am 
Offline
Of Systemic Importance
User avatar

Joined: Aug 20, 2009
Posts: 5063
So when I want to post some data on a thread I do the following:

I do up the data in Excel 2010, paste it into Word 2010 as a picture, then save it as a separate Png file. I then upload the png file to Imgur. At this stage it goes from perfectly readable to not so much.

Any suggestions on a good font type/size to stop this unreadable problem?

I've tried smaller sized fonts, arial, trebuchet, roman, calibri - all seem to not work!


Top
 Profile  
 
 Post subject: Re: Best font for charts?
PostPosted: Thu Feb 25, 2016 11:46 am 
Offline
Of Systemic Importance

Joined: Sep 13, 2012
Posts: 5194
Word? Just do a screenshot from Excel, using Lightshot or whatever.

What operating system are you using?

_________________
"It's easy to confuse what is with what ought to be, especially when what is has worked out in your favour"
Tyrion Lannister


Top
 Profile  
 
 Post subject: Re: Best font for charts?
PostPosted: Thu Feb 25, 2016 12:04 pm 
Offline
Of Systemic Importance
User avatar

Joined: Aug 20, 2009
Posts: 5063
Eschatologist wrote:
Word? Just do a screenshot from Excel, using Lightshot or whatever.

What operating system are you using?


Windows 7 mostly. Have 10 on my laptop. Never used Lightshot before


Top
 Profile  
 
 Post subject: Re: Best font for charts?
PostPosted: Thu Feb 25, 2016 12:39 pm 
Offline
Nationalised
User avatar

Joined: Jan 1, 1970
Posts: 22908
TheJackal wrote:
So when I want to post some data on a thread I do the following:

I do up the data in Excel 2010, paste it into Word 2010 as a picture, then save it as a separate Png file. I then upload the png file to Imgur. At this stage it goes from perfectly readable to not so much.

Any suggestions on a good font type/size to stop this unreadable problem?

I've tried smaller sized fonts, arial, trebuchet, roman, calibri - all seem to not work!


Arial or Calibri should be fine. If you have it try lucida grande.

How did you make the PNG of that graph?

There is no anti-aliasing on the font or font smoothing, the reason being is possibly you created a 2 or 4 colour PNG w/transparence because it looks like the pixels using stepped try tone used to smooth around the edge of the font only had one colour to use and that was black, so all pixel that where not transparent became black! :shock:

That's my guess.

_________________
Follow The Pin - https://twitter.com/dailypinster

"Politicians are always realistically maneuvering for the next election. They are obsolete as fundamental problem-solvers." - Buckminster Fuller

"I was comfortable with a couple of banks being married today, instead i wake up and find I'm married to the banks." - Catbear

Image


Top
 Profile  
 
 Post subject: Re: Best font for charts?
PostPosted: Thu Feb 25, 2016 1:12 pm 
Offline
Of Systemic Importance

Joined: Sep 13, 2012
Posts: 5194
TheJackal wrote:
Eschatologist wrote:
Word? Just do a screenshot from Excel, using Lightshot or whatever.

What operating system are you using?


Windows 7 mostly. Have 10 on my laptop. Never used Lightshot before

You need to reduce the number of conversion steps by avoiding Word, and if possible upload without resizing.

I use postimage.org to host screenhots using the "don't resize my image" option, presumably imgur has a similar option. The only wrinkle is if you're using a high DPI display the unscaled images can appear quite large to other people when posted in a forum like this.

_________________
"It's easy to confuse what is with what ought to be, especially when what is has worked out in your favour"
Tyrion Lannister


Top
 Profile  
 
 Post subject: Re: Best font for charts?
PostPosted: Thu Feb 25, 2016 1:50 pm 
Offline
Of Systemic Importance
User avatar

Joined: Aug 20, 2009
Posts: 5063
Cheers all. I'll test some more later


Top
 Profile  
 
 Post subject: Re: Best font for charts?
PostPosted: Thu Feb 25, 2016 3:29 pm 
Offline
Single Home Owner

Joined: Apr 8, 2013
Posts: 193
To Export it directly from excel you can create the following macro to export and save the chart
Change "C:\Folder\ChartName.png" in code below to your folder and filename

Sub Export_chart()
With ActiveChart
ActiveChart.Export "C:\Folder\ChartName.png"
End With
End Sub


Top
 Profile  
 
 Post subject: Re: Best font for charts?
PostPosted: Thu Feb 25, 2016 4:26 pm 
Offline
Nationalised
User avatar

Joined: Apr 1, 2010
Posts: 10409
You don't need any exporting at all. Right click the chart in Excel and select 'Copy'. Go to imgur.com and hit Ctrl/V to paste (browser-dependent, works in Firefox, Chrome and others). Hit return to upload without resizing. That's it.

_________________
"Prediction is very difficult, especially about the future" – Niels Bohr


Top
 Profile  
 
 Post subject: Re: Best font for charts?
PostPosted: Thu Feb 25, 2016 7:02 pm 
Offline
Under CAB Investigation

Joined: Nov 26, 2008
Posts: 1504
Just don't use Comic-sans, there's a good lad.

Arial or Arial Bold would be my choice.

_________________
The bust is getting bustier.....


Top
 Profile  
 
 Post subject: Re: Best font for charts?
PostPosted: Fri Feb 26, 2016 12:00 am 
Offline
Old Time Landlord

Joined: Jun 23, 2011
Posts: 382
If you're going to publish to imgur, just copy in excel and paste directly to imgur (ctrl+v)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

    Board index » The Property Pin Website - Open Development » The Property Pin Website Open Development Forum

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Jump to:  

Follow, Retweet @dailypinster



Pyramid Built, Is Better Built! - Latest Property Discussions www.thepropertypin.com