Forum Discussion
Simple macro
How can i write a simple macro to allow me to change data in my spreadsheet to display on a graph?
for example have 10x2 would display as 2, 10x3 would display as 3, 10x4 would display as 4 etc
Not quite sure I comprehend what you're trying to do.... Is it something like this (see attached .xlsx)?:
i want to log on my report results as follows:
<102,102, 103,104,105,106, and want to produce a simple graph from a data sheet so want it to show 0,2, 3, 4, 5, 6 etc on my data sheet
if possible it would be great if i could also do 102(1cfu), and show 1
Hope this helps
Not quite sure I comprehend what you're trying to do.... Is it something like this (see attached .xlsx)?:
Matt
Yes it is basically my values on a report sheet will be as in the middle column on the left, what i want it to show on the data sheet i use to produce the graphs will be as in the right columns.
Matt
Still not sure how i get this to work on my excelsheet
Cheers Mark
