Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


mdf

mdf

3512 posts

Uber Geek

Trusted

#201609 26-Aug-2016 12:48
Send private message

My google-fu has failed me.

 

I am trying to turn this:

 

 

Into something that looks a bit like this:

 

 

i.e. an item is assigned to "matrix" box and displayed visually depending on it's categorisation in two separate categories (which are in this case literally 1 through 4 and A through D, though in practice there will be a lot more than 8 items to be matrixized.

 

Google has been my friend many times in the past for Excel queries, but in this case I'm not even sure the name or description of what I'm looking for. I can't imagine I will get what I want out of a simple function/chart, fully expecting to have to VB this.


Create new topic
BlueShift
1692 posts

Uber Geek


  #1617842 26-Aug-2016 13:04
Send private message

Looks a bit like a Pivot table. I'd start there.




KrazyKid
1238 posts

Uber Geek


  #1617852 26-Aug-2016 13:22
Send private message

Also looks like a could be a scatter plot with the points being unique date if you ignore the colors.

 

Maybe try xyz scatterplot or 3d Scatter plot?

 

Good luck


MikeAqua
7773 posts

Uber Geek


  #1617873 26-Aug-2016 13:53
Send private message

Would an area plot work for you?





Mike




mdf

mdf

3512 posts

Uber Geek

Trusted

  #1618014 26-Aug-2016 18:07
Send private message

Thanks everyone. All the suggestions got close but not quite what I was looking for.

 

In the end sorted it out by setting up the matrix chart how I wanted it, then using this script to create a ConcatenateIfs function. I then used this function to "pull" in the data that matched the X/Y criteria, so got all the items listed nicely in the relevant cells.


TwoSeven
1623 posts

Uber Geek

Subscriber

  #1618029 26-Aug-2016 18:40
Send private message

You could probably do it in power query (get and transform) in excel. You write a m script to select your source data and for each row, stick a category on it, the take the result and create your output data table formatted the way you want.




Software Engineer
   (the practice of real science, engineering and management)
A.I.  (Automation rebranded)
Gender Neutral
   (a person who believes in equality and who does not believe in/use stereotypes. Examples such as gender, binary, nonbinary, male/female etc.)

 

 ...they/their/them...


Create new topic





News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00


eero Pro 7 Review
Posted 23-Jul-2025 12:07


BeeStation Plus Review
Posted 21-Jul-2025 14:21


eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01


WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32


RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26


Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24


Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05


Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01


Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01


Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22


Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46


Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42


D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34


Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15









Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.