Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

representing pies as selected countries Expand / Collapse
Author
Message
Posted Friday, June 6, 2014 3:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 8, 2014 6:49 PM
Points: 27, Visits: 82
ok i did not pay attention ,in fact i did the example he has done but me what i want that i have just one column for categore and one for country

so that i get this
graphic






  Post Attachments 
country.png (3 views, 7.40 KB)
Post #1578218
Posted Friday, June 6, 2014 4:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:46 AM
Points: 13,646, Visits: 11,524
What if you drop the pie chart on the rows, instead of the columns?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1578221
Posted Friday, June 6, 2014 4:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 8, 2014 6:49 PM
Points: 27, Visits: 82
there is just one cell for data what did you mean by draging it in row ?

  Post Attachments 
country.png (4 views, 7.40 KB)
Post #1578228
Posted Friday, June 6, 2014 5:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:46 AM
Points: 13,646, Visits: 11,524
prepaess (6/6/2014)
there is just one cell for data what did you mean by draging it in row ?


The category group (country in your case) should be on the rows, not on the columns.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1578251
Posted Friday, June 6, 2014 6:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 8, 2014 6:49 PM
Points: 27, Visits: 82
i solved the problem in fact i keep just one row country and then put the chart in data
but my problem is now in the legend it is not the same for all pies what should i do ?
thanks a lot for any help


  Post Attachments 
prob.png (2 views, 14.17 KB)
Post #1578254
Posted Friday, June 6, 2014 6:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:46 AM
Points: 13,646, Visits: 11,524
You probably need to sort on Type.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1578260
Posted Friday, June 6, 2014 10:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:29 AM
Points: 367, Visits: 905
Then create an account and log in and download it, like an adult.
Post #1578406
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse