I would like to have a line chart with 5 lines. the data for the 5 sets of data are all contained in one column, see attached file
$20 Create a line chart
-
-
-
Hi,
I will take a look at your request and let you know if I have any questions.
-
Hi,
I have a solution ready for you. I will send you payment details via PM.
Note: did you pay 10% to Ozgrid?
Thanks,
-
hi,
I also payed ozgrid 10%, transaction ID : 4JR87417NL840545P
-
Hi,
Thanks for the payment !
Please find attached the file with the macro.
Simply, copy the data in the first sheet and then go to the second sheet (Chart) and click the button to generate the chart.
If you select a bookie in N1 and click the button, it will be highlighted (line thicker).
-
-
Hello,
Thanks for your work, it looks realy nice, just what I wanted, just a small detail if posible
Can the vertical axis be scaled automaticaly , in this case the minimum value of our data is 2,02, and I would like the vertical scale to start at (2,02/1,01), of course this should be a calculation since the minimum amount can vary dramaticaly.
Thanks
Carlos
-
Hi,
Sure it is possible. It can be a variable that you can change (like the Bookie name).
Or provide me a few more examples, so I can understand the logic to set the minimum value...
Thanks
-
Hi,
QuoteIt can be a variable that you can change (like the Bookie name)
I would prefer it to be a calculation, as the data will be entered from Ms access programaticaly with no user intervention. Even the bookie name will come from Access , but that I will adapt to my code.
I attached some more examples of data with different data
-
Hi,
Here's a new version of the file. Scale is adjust based on min and max values found (rounded to next integer)
-
Hello
It is fine now. Only that the chart does not display the full range of data ( 452 rows)
-
-
I am thinking that perhaps the way the data that I sent you is strutured , would make it hard to display the chart as I want , with the full range of data ( 452 rows) . I am right ?
-
Hi,
The number of rows shouldn't matter.
Can you attach file with that you say is not working, so I can investigate...
Are you data the same date/time? I'm asking because in the last 3 files you attached. the data was for the dame hour with more that 5 bookies...
For example in the "chelsea" files, the 227 rows are all on 8-Feb 15h...
-
thanks, everything is working properly now
-
Thanks for the feedback.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!