UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> What Type Of Chart Should I Use, Office 2013    
 
   
baffled100
post Mar 14 2020, 07:55 PM
Post#1



Posts: 432
Joined: 10-December 12



Hi,

I'm very much a beginner in the world of fancy Excel charts and I did spend some time looking for help on the web, but I was beginning to waste time. I'm hoping someone can point me in the right direction of what type of chart I would need to chart the data in the attached worksheet. It is data exported from an Access table. I started off summarizing the data in a crosstab query, but then got stuck. In the attached file, I have the exported data from both the table and from the crosstab query.

Many, many thanks!

Attached File(s)
Attached File  Cell_service_survey.zip ( 9.87K )Number of downloads: 2
 
Go to the top of the page
 
June7
post Mar 14 2020, 08:18 PM
Post#2



Posts: 1,307
Joined: 25-January 16
From: The Great Land


Excel can do a bar or line chart. A set of 4 bars or lines (calls, texts, video, number of bars) for each provider/studio pair. Problem is, provider text is too wide for display on chart - overlaps.

This is on the Cell service survey sheet.

Looks like really need to first do an aggregate query to group on provider/studio - not a crosstab. I am guessing would want to sum calls, texts, video and average number of bars.
This post has been edited by June7: Mar 14 2020, 09:05 PM

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page
 
MadPiet
post Mar 14 2020, 08:36 PM
Post#3



Posts: 3,565
Joined: 27-February 09



What kinds of questions are you trying to answer about the data?
Go to the top of the page
 
baffled100
post Mar 25 2020, 01:14 PM
Post#4



Posts: 432
Joined: 10-December 12



Thanks so much for your reply, June7. I'm not sure I follow what you are suggesting, to group on provider/studio. There are 30 studios and 5 providers, so there would be 150 grouped items..? I wouldn't sum the texts, calls, video--the numbers are a rating of the service for each, not the number of each.

I created 4 separate bar charts, but I was hoping to be able to somehow combine them into one chart. I read about combining two sets of data, but I have four! Oh well, it doesn't seem possible....thanks for your help anyways!
Go to the top of the page
 
June7
post Mar 26 2020, 12:29 AM
Post#5



Posts: 1,307
Joined: 25-January 16
From: The Great Land


Excel easily creates a bar chart that has all 4 data groups. What exactly do you want to chart - average ratings and number of calls for each studio/provider pair? Would have to first build aggregate query in Access and export that to Excel.

Access can also do bar chart.

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    2nd April 2020 - 07:24 PM