Home Page Knowledge Base Support Forum Free Downloads

Trend Widget

Please post your comments related to configuring the ExcelDashboardWidgets spreadsheets here.

Moderator: DashboardWidgets

Trend Widget

Postby apmitch » Thu Feb 06, 2014 7:47 am

Dear Sirs, please help. I am a new user and have started to put my Dashboard together, no problems with the Widgets, the only problem I have is using the Trend Widget! I have three trends which are required, I have successful got three trends on my graph, but its the Date which I cannot sort out? For example I will run my chart every month, hence; Jan Feb Mar etc, but when I look at my chart its got all odd dates in the axis? can you or some body please advise? I am missing some thing?

Thanks in advance for your help.
Posts: 2
Joined: Mon Feb 03, 2014 5:34 am

Re: Trend Widget

Postby DashboardWidgets » Mon Feb 10, 2014 10:21 pm

Dear apmitch

As you've probably figured out by now, the trend widget is very simply a standard Excel XY graph that has been formatted to fit in with the same style of the other widgets.

If you want to change the date axis you need to ungroup the widget and format the chart axis - exactly the same as you would with a standard graph in Excel (right click on the axis and choose format axis) - see the figure below...


To set the min date and max date for the graph I usually just enter the dates directly into the format axis dialog box e.g. "01/01/12" and "01/03/12". You then need to play with the scale interval so you don't get overlapping text e.g. in this case I put a scale label every 10 days.

Hope this helps - an alternative is that you can just delete the XY graph and overlay one of your own which has all your data nicely formatted how you like it!

Anyhow, if any of this doesn't make sense please feel free to get back to us.

Warmest regards

Posts: 332
Joined: Mon May 30, 2011 7:06 pm

Re: Trend Widget

Postby JJCostello » Wed Sep 17, 2014 10:41 pm

I have the same issue with the trend widget. I need to display time intervals monthly or quarterly but the suggested format axis option only appears to allow intervals to be set in days, which doesn't work given the different lengths of months.
I have been burning the midnight oil trying to find the answer without success so would appreciate any guidance. I appreciate that I could put a new Excel scatter graph in but losing the formatting seems to defeat the object of creating a sharp-looking dashboard! Thanks in advance.
Posts: 1
Joined: Tue Sep 16, 2014 8:44 am

Re: Trend Widget

Postby DashboardWidgets » Thu Sep 18, 2014 12:43 pm

Hi JJCostello

Take a look at the attached - we basically took the Excel Trend Widget and changed the axis settings so that is works for Quarterly, Monthly, Weekly and Daily time frames.

Excel Trend Widget with Different Time Frames.jpg

The unlocked version can be found in the Commercial Licence Holder's Download Area here...

I hope this helps and please feel free to post another message if you require further support.


Posts: 332
Joined: Mon May 30, 2011 7:06 pm

Return to 1. Configuring the Spreadsheets

Who is online

Users browsing this forum: No registered users and 1 guest