Line charts - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Line charts

Author

Topic

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2009-05-27 : 03:46:36

Hi,

I have the following data plotted in a line chart
TotalReported date_Reported
11 10 May 2009
11 26 May 2009
9 14 May 2009
9 24 May 2009
8 25 May 2009
8 18 May 2009
7 13 May 2009
7 17 May 2009
6 11 May 2009
6 19 May 2009
5 20 May 2009
5 12 May 2009
3 21 May 2009
2 07 May 2009

The chart comes out as follows and i was wondering how to make the chart look more presentable as the client doesn't like it now:

Thanks

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

savior faire
Posting Yak Master

194 Posts

Posted - 2009-05-27 : 06:24:33

Something does not look right with the chart. The line on the chart is telling me that most of the dates on the chart have multiple input values. For example, the date 5/19/09 is showing eight data points.

Talk sense to a fool and he calls you foolish.

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2009-05-30 : 10:03:02

Hi

My data has only value for the dates. What is the correct way to plot the values?
Thanks
TotalReported date_Reported
11 10 May 2009
11 26 May 2009
9 14 May 2009
9 24 May 2009
8 25 May 2009
8 18 May 2009
7 13 May 2009
7 17 May 2009
6 11 May 2009
6 19 May 2009
5 20 May 2009
5 12 May 2009
3 21 May 2009
2 07 May 2009

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources