Qualquer dúvida sobre gráficos, como criá-los, alterar eixos principais e secundários, adicionar/remover categorias e séries, legendas e rótulos, etc.
Por mteves 29 Jun 2020 às 00:24
Membro Novato
Mensagens: 1
Reputação: 0
#56574
URGENTE:

Eu tenho 1914 valores (estão em baixo) e preciso de fazer um histograma que me diga quantas vezes é que cada valor se repete. Para depois poder criar classes para os valores e voltar a fazer outro histograma. Como é que consigo fazer o primeiro histograma?

0,673
0,701
0,746
0,748
0,762
0,768
0,769
0,843
0,881
0,883
0,902
0,903
0,905
0,909
0,917
0,919
0,925
0,926
0,927
0,928
0,930
0,934
0,936
0,940
0,942
0,944
0,949
0,949
0,951
0,953
0,955
0,955
0,957
0,957
0,962
0,962
0,963
0,963
0,963
0,964
0,964
0,964
0,966
0,966
0,967
0,967
0,967
0,968
0,969
0,972
0,972
0,973
0,976
0,978
0,980
0,981
0,981
0,984
0,984
0,985
0,986
0,987
0,989
0,993
0,993
0,993
0,994
0,994
0,994
0,994
0,995
0,995
0,996
0,996
0,996
0,997
0,998
0,999
0,999
1,001
1,001
1,001
1,003
1,003
1,004
1,004
1,004
1,006
1,007
1,008
1,009
1,009
1,009
1,010
1,010
1,011
1,011
1,011
1,012
1,012
1,013
1,014
1,015
1,015
1,015
1,015
1,017
1,017
1,017
1,017
1,017
1,017
1,019
1,019
1,021
1,022
1,022
1,023
1,023
1,024
1,025
1,025
1,025
1,026
1,029
1,034
1,035
1,035
1,036
1,039
1,039
1,044
1,044
1,044
1,044
1,045
1,046
1,046
1,046
1,047
1,048
1,048
1,049
1,051
1,051
1,053
1,057
1,057
1,058
1,059
1,060
1,062
1,063
1,064
1,066
1,068
1,068
1,069
1,069
1,072
1,072
1,074
1,074
1,076
1,076
1,078
1,080
1,082
1,082
1,083
1,084
1,085
1,086
1,091
1,091
1,091
1,091
1,092
1,092
1,092
1,092
1,093
1,094
1,094
1,096
1,097
1,098
1,099
1,100
1,100
1,100
1,102
1,102
1,103
1,103
1,103
1,104
1,105
1,106
1,106
1,106
1,107
1,107
1,107
1,107
1,107
1,108
1,108
1,109
1,109
1,109
1,109
1,110
1,110
1,110
1,111
1,112
1,112
1,113
1,113
1,113
1,114
1,114
1,114
1,114
1,115
1,115
1,116
1,116
1,116
1,116
1,117
1,117
1,117
1,117
1,118
1,118
1,118
1,118
1,118
1,118
1,118
1,119
1,119
1,119
1,120
1,120
1,120
1,121
1,121
1,121
1,122
1,122
1,122
1,122
1,123
1,123
1,123
1,123
1,123
1,123
1,124
1,124
1,124
1,124
1,124
1,124
1,125
1,126
1,127
1,127
1,127
1,128
1,128
1,128
1,128
1,128
1,128
1,128
1,129
1,130
1,130
1,130
1,130
1,130
1,131
1,131
1,131
1,131
1,132
1,132
1,132
1,132
1,133
1,133
1,133
1,133
1,133
1,133
1,133
1,134
1,134
1,134
1,134
1,134
1,134
1,135
1,135
1,135
1,135
1,135
1,135
1,135
1,135
1,135
1,136
1,136
1,136
1,136
1,136
1,136
1,136
1,136
1,136
1,136
1,136
1,137
1,137
1,137
1,137
1,138
1,138
1,138
1,138
1,139
1,139
1,139
1,140
1,140
1,140
1,140
1,140
1,141
1,141
1,141
1,141
1,141
1,141
1,141
1,141
1,141
1,141
1,141
1,141
1,142
1,142
1,142
1,142
1,142
1,142
1,142
1,143
1,143
1,143
1,143
1,143
1,143
1,143
1,143
1,143
1,143
1,143
1,144
1,144
1,144
1,144
1,144
1,144
1,144
1,144
1,144
1,144
1,144
1,144
1,145
1,145
1,146
1,146
1,146
1,146
1,146
1,146
1,146
1,146
1,146
1,146
1,147
1,147
1,147
1,147
1,147
1,148
1,148
1,148
1,148
1,148
1,148
1,148
1,148
1,149
1,149
1,149
1,149
1,149
1,149
1,150
1,150
1,150
1,150
1,150
1,150
1,150
1,150
1,150
1,150
1,150
1,150
1,150
1,150
1,150
1,151
1,151
1,151
1,151
1,151
1,152
1,152
1,152
1,152
1,152
1,152
1,152
1,152
1,152
1,152
1,152
1,152
1,152
1,152
1,153
1,153
1,153
1,153
1,153
1,153
1,153
1,153
1,153
1,153
1,154
1,154
1,154
1,154
1,154
1,154
1,154
1,154
1,154
1,154
1,154
1,154
1,154
1,154
1,154
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,155
1,156
1,156
1,156
1,156
1,156
1,156
1,156
1,156
1,156
1,156
1,156
1,156
1,157
1,157
1,157
1,157
1,157
1,157
1,157
1,157
1,157
1,158
1,158
1,158
1,158
1,159
1,159
1,159
1,159
1,159
1,159
1,159
1,159
1,159
1,160
1,160
1,160
1,160
1,160
1,160
1,160
1,160
1,161
1,161
1,161
1,161
1,161
1,161
1,161
1,161
1,162
1,162
1,162
1,162
1,162
1,162
1,162
1,163
1,163
1,163
1,163
1,163
1,163
1,163
1,163
1,163
1,163
1,163
1,163
1,163
1,163
1,163
1,163
1,164
1,164
1,164
1,164
1,164
1,164
1,164
1,164
1,164
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,165
1,166
1,166
1,166
1,166
1,166
1,166
1,166
1,166
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,167
1,168
1,168
1,168
1,168
1,168
1,168
1,168
1,168
1,168
1,168
1,168
1,168
1,168
1,169
1,169
1,169
1,169
1,169
1,169
1,170
1,170
1,170
1,170
1,170
1,170
1,170
1,170
1,170
1,170
1,170
1,170
1,171
1,171
1,171
1,171
1,171
1,171
1,171
1,171
1,171
1,171
1,172
1,172
1,172
1,172
1,172
1,172
1,172
1,172
1,172
1,172
1,172
1,172
1,172
1,172
1,172
1,172
1,173
1,173
1,173
1,173
1,173
1,173
1,173
1,173
1,173
1,173
1,173
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,174
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,175
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,176
1,177
1,177
1,177
1,177
1,177
1,177
1,177
1,177
1,177
1,177
1,177
1,177
1,177
1,178
1,178
1,178
1,178
1,178
1,178
1,178
1,178
1,178
1,179
1,179
1,179
1,179
1,179
1,179
1,180
1,180
1,180
1,180
1,180
1,180
1,180
1,180
1,180
1,180
1,180
1,180
1,180
1,180
1,180
1,181
1,181
1,181
1,181
1,181
1,181
1,181
1,181
1,181
1,181
1,181
1,181
1,181
1,181
1,181
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,182
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,183
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,184
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,185
1,186
1,186
1,186
1,186
1,186
1,186
1,186
1,186
1,186
1,186
1,186
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,187
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,188
1,189
1,189
1,189
1,189
1,189
1,189
1,189
1,189
1,189
1,189
1,189
1,189
1,189
1,190
1,190
1,190
1,190
1,190
1,190
1,190
1,190
1,190
1,190
1,191
1,191
1,191
1,191
1,191
1,191
1,191
1,191
1,191
1,191
1,191
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,192
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,193
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,194
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,195
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,196
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,197
1,198
1,198
1,198
1,198
1,198
1,198
1,198
1,198
1,198
1,198
1,198
1,198
1,198
1,199
1,199
1,199
1,199
1,199
1,199
1,199
1,199
1,199
1,199
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,201
1,201
1,201
1,201
1,201
1,201
1,201
1,201
1,201
1,201
1,201
1,201
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,202
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,203
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,204
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,205
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,206
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,207
1,208
1,208
1,208
1,208
1,208
1,208
1,208
1,208
1,208
1,208
1,209
1,209
1,209
1,209
1,209
1,209
1,209
1,209
1,209
1,209
1,209
1,210
1,210
1,210
1,210
1,210
1,210
1,210
1,210
1,210
1,210
1,210
1,210
1,211
1,211
1,211
1,211
1,211
1,211
1,211
1,211
1,212
1,212
1,212
1,212
1,212
1,212
1,212
1,212
1,212
1,212
1,212
1,212
1,212
1,212
1,213
1,213
1,213
1,213
1,213
1,213
1,213
1,213
1,213
1,213
1,213
1,213
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,214
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,215
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,216
1,217
1,217
1,217
1,217
1,217
1,217
1,217
1,217
1,217
1,217
1,217
1,217
1,217
1,217
1,217
1,218
1,218
1,218
1,218
1,219
1,219
1,219
1,219
1,219
1,219
1,219
1,219
1,219
1,219
1,219
1,219
1,219
1,219
1,219
1,219
1,220
1,220
1,220
1,220
1,220
1,220
1,220
1,220
1,220
1,221
1,221
1,221
1,221
1,221
1,221
1,221
1,221
1,221
1,221
1,221
1,221
1,221
1,221
1,221
1,222
1,222
1,222
1,222
1,222
1,222
1,222
1,222
1,222
1,222
1,222
1,222
1,222
1,222
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,223
1,224
1,224
1,224
1,224
1,224
1,224
1,224
1,224
1,224
1,224
1,224
1,224
1,224
1,224
1,224
1,225
1,225
1,225
1,225
1,225
1,225
1,225
1,225
1,225
1,225
1,225
1,225
1,225
1,225
1,225
1,226
1,226
1,226
1,226
1,226
1,226
1,226
1,226
1,226
1,226
1,226
1,226
1,226
1,226
1,226
1,227
1,227
1,227
1,227
1,227
1,227
1,227
1,227
1,227
1,227
1,227
1,227
1,228
1,228
1,228
1,228
1,228
1,228
1,228
1,228
1,228
1,228
1,228
1,228
1,229
1,229
1,229
1,229
1,229
1,229
1,229
1,229
1,229
1,229
1,229
1,229
1,230
1,230
1,230
1,230
1,230
1,230
1,230
1,230
1,230
1,230
1,231
1,231
1,231
1,231
1,231
1,231
1,231
1,231
1,231
1,232
1,232
1,232
1,232
1,232
1,232
1,232
1,232
1,232
1,232
1,233
1,233
1,233
1,233
1,233
1,233
1,233
1,233
1,233
1,233
1,234
1,234
1,234
1,234
1,234
1,234
1,234
1,234
1,234
1,234
1,234
1,234
1,234
1,235
1,235
1,235
1,235
1,235
1,235
1,235
1,235
1,235
1,236
1,236
1,236
1,236
1,236
1,236
1,236
1,236
1,237
1,237
1,237
1,237
1,237
1,237
1,237
1,237
1,237
1,237
1,237
1,237
1,237
1,238
1,238
1,238
1,238
1,238
1,238
1,238
1,238
1,238
1,238
1,238
1,238
1,239
1,239
1,239
1,239
1,239
1,240
1,240
1,240
1,240
1,240
1,240
1,240
1,240
1,241
1,241
1,241
1,241
1,241
1,241
1,241
1,241
1,241
1,242
1,242
1,242
1,242
1,242
1,242
1,242
1,242
1,242
1,242
1,242
1,243
1,243
1,243
1,243
1,243
1,243
1,244
1,244
1,244
1,244
1,244
1,244
1,244
1,244
1,245
1,245
1,245
1,245
1,245
1,245
1,245
1,245
1,245
1,245
1,245
1,245
1,246
1,246
1,246
1,246
1,246
1,246
1,247
1,247
1,247
1,247
1,247
1,247
1,247
1,247
1,247
1,247
1,247
1,248
1,248
1,248
1,248
1,248
1,248
1,249
1,249
1,249
1,249
1,249
1,249
1,249
1,249
1,249
1,249
1,250
1,250
1,251
1,251
1,251
1,251
1,251
1,251
1,251
1,251
1,252
1,252
1,252
1,252
1,252
1,252
1,253
1,253
1,253
1,253
1,253
1,253
1,253
1,253
1,253
1,254
1,254
1,254
1,254
1,254
1,254
1,255
1,255
1,255
1,255
1,255
1,256
1,256
1,256
1,256
1,256
1,256
1,256
1,257
1,257
1,258
1,258
1,258
1,258
1,258
1,259
1,259
1,259
1,259
1,260
1,260
1,260
1,260
1,260
1,261
1,261
1,261
1,261
1,262
1,262
1,263
1,263
1,263
1,263
1,263
1,263
1,263
1,263
1,263
1,263
1,263
1,263
1,263
1,264
1,264
1,264
1,265
1,265
1,265
1,265
1,265
1,265
1,265
1,266
1,266
1,266
1,266
1,267
1,267
1,267
1,267
1,268
1,268
1,269
1,269
1,270
1,271
1,271
1,271
1,271
1,271
1,271
1,272
1,272
1,273
1,274
1,275
1,276
1,279
1,279
1,279
1,279
1,280
1,280
1,280
1,283
1,283
1,283
1,284
1,285
1,285
1,286
1,287
1,287
1,292
1,293
1,295
1,295
1,298
1,299
1,299
1,299
1,305
1,308
1,333
1,340
1,347
1,350
1,907
Por babdallas 29 Jun 2020 às 08:12
Excel Expert
Mensagens: 2941
Reputação: 1279
#56585
Fiz com tabela dinâmica. Seria isso?
Apenas usuários registrados podem ver ou baixar anexos.