LinkBack URL
About LinkBacks
Hi,
I have a question.
I have a series of results like this:
Screenshot_2.png
And I want a graph (not a worksheet) that updates constantly to my results that looks something like this:
Screenshot_1.png
Any idea?
Matrix Graphing (like battleship)
Hi,
I have a question.
I have a series of results like this:
Screenshot_2.png
And I want a graph (not a worksheet) that updates constantly to my results that looks something like this:
Screenshot_1.png
Any idea?
I don't see the logic in the coloring.
Entia non sunt multiplicanda sine necessitate
The coloring would be bars on the chart, representing the spacial location of items 1 and 2.
In my example, I have Item 2 in locations(x,y) B1, a2 and a3, that is represented below in orange as occupying those locations.
Did I explain myself right? It's a bit confusing, but is much simular to battleship board game.
Screenshot_3.png
This is the same as I sent before but without the colours.
I would like a bar chart with different color for each item so that I can se the spacial representation of those items (It's for and industry that has different items of fixed bench locations).
B8: {=IF(OR(EXACT($A8 & B$7, $A$2:$A$5)), $A$1, IF(OR(EXACT($A8 & B$7, $B$2:$B$5)), $B$1, ""))}
Tks, I see what you are doing there, but I don't want a formula to fill the matrix, I wanted a bars graph of something like that to visually spot the items.
Because the items can be as much as 15 or 20 and they have large names, so a colour or bar graph would be more appropriate.
Then use the two OR functions for CF:
=OR(EXACT($A8 & B$7, $A$2:$A$5))
=OR(EXACT($A8 & B$7, $B$2:$B$5))
Tks for your help and sry that doesn't do.
But it has to be a graph and not just cell filling or coloring.
A graph like a map with x and y coordinates, beeing x the numbers and y the letters.
Instead of showing a graphic of what you do not want, how about mocking up something that looks like what you DO want? There is too much guesswork here: help us to help you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Re: Matrix Graphing (like battleship)
You're right.
So, I'll try to explain better, sketched something up like I would need on photoshop.
This is just a sample of the set of data that I have regarding 2 batch numbers (the letters represent the "x" coordinates on the tables, and the numbers the "y" coordinates on the tables, with the batch numbers on top ).
Screenshot_4.png
This is the graph that I want to be shown:
Graph1.png
The batch numbers and positions can be in constant change, so I need the graph to know where are the product batch numbers positioned on the tables, and it can't be by CF because the constant change, adding up of new batches, removing some could not automate the process.
Does this sound clearer than before?
Sry by all the "messy" idea transfer here.
Last edited by n4rs; 10-31-2018 at 06:45 AM.
Yes - I am wondering if this is doable using conditional formatting. How many items will there be? How big is the dataset?
Table space is from "A" to "h" coordinate on y axis (8 coordinates), and 1 to 5 coordinate on x axis. Making a total of 40 spaces (or vice versa, not that important if letters on y or x)
Batch numbers can vary from 0 to 40 different batches that can change weekly or daily, some remain more time than others.
I have automated the process of traceability recording for the batch numbers, simplifying it with VBA userforms, but can't find a way to visually demonstrate their positions on the tables.
IMO conditional formatting can't be that dynamic (or at least I don't think so), cause the user has to be blocked to just use the forms.
OK, then CF is not really an option. Maybe someone has a better idea.
I think it could be done with a scatter graph somehow
To create a scatter chart you need to decode the A1 a1 items in to x and y values.
That's really it! Seems a lot simpler than the options I had already tried! Tk you very much!!
But is there a way that I can do it with VBA code so that each time a new batch enters, the graph will be updated with the form values entered, as well as each time a batch leaves or changes places?
I have the following entry form:
Entryform.png
Each checkbox represents a coordinate (On the letter coordinates the bigger checkboxes represent the uppercase letters, the smaller ones right beneath represent the lowercase letters).
Last edited by n4rs; 10-31-2018 at 08:40 AM.
if you have a fixed input then you could link the checkboxes to cells and base formula of the those to create a xy value.
You probably don't need to decode the A1 a1 stuff. But it's hard to say as you haven't describe your problem or provided an example workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks