ExcelDashboardWidgets

PostPosted:**Sat Apr 08, 2017 5:34 pm**

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.

PostPosted:**Thu Apr 13, 2017 8:07 am**

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

DashboardWidgets

PostPosted:**Sat Nov 18, 2017 8:27 am**

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.

PostPosted:**Sat Nov 18, 2017 10:30 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

JJCostello Trend Widget Setup for Different Timeframes.xlsx

(45.29 KiB) Downloaded 1095 times

The unlocked version can be found in the Commercial Licence Holder's Download Area here...
http://www.exceldashboardwidgets.com/ph ... f=25&t=433

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

Cheers

DashboardWidgets