Hi
I am having the same problem (129 entries, Excel 2010), but my x-axis has date and hour formatting (dd/mm/yyyy hh:mm) so I can't get Andy's solution to work. Has anyone come up with any other workarounds? I also have found that using the 'automatic' option will give every label, but only when the chart is stupidly huge and so once copied into Word doc the labels are illegible!
Grateful for any assistance!
Admin Note: Linked from: http://www.excelforum.com/excel-char...is-labels.html
Last edited by arlu1201; 06-21-2013 at 08:44 AM.
Why won't that approach work?
Can you post example workbook
Hi Andy - thanks for quick response!
Maybe I'm misunderstanding your approach, but I don't seem to be able to keep the date/hour formatting in column A. Not sure how to post attachments on here - new to this forum stuff
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic[/QUOTE]
Hope this works - should be the data and chart I'm trying to produce. Attachment 244700
Like this?
Like this?
Note to mods: you might also want to move the reply I did to the original thread.
Cool - thanks, Andy - so how does that work then?
It works as described in the other thread.
The axis labels are faked using the data labels of an additional series. In this case I add a line series, with zero values, then displayed the Category in data labels.
Hmm, I see. Simple and elegant - I like it. Thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks