Bubble chart with duplicate data points

  • Thread starter need helpful advice
  • Start date
N

need helpful advice

I have a list with duplicate data points that I would like represented only
once. i.e. - right now I get 5 Mon when I would like them all to be plotted
on the same Mon.

Day (x) Time (y) Count (z)

Mon 0:00 1
Mon 9:00 1
Mon 11:00 1
Mon 15:00 1
Mon 22:00 1
Tues 0:00 1
Tues 1:00 2
Tues 2:00 1
Tues 14:00 1
Tues 15:00 1
Tues 16:00 1
Wed 0:00 1
Wed 14:00 2
Wed 22:00 8

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

do not chart rows with no information 4
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
15 minute data to daily data 1
Graph usage for times of day 0
Employee Schedule not plotting properly - chart type / data series not correct 0
Calculating occupational sick pay entitlement 0
LOOKUP function?? 5
Problem formatting dates from CSV file 2

Top