Search results for query: *

  1. H

    Linear Axis Scale

    Ok, great thanks for your help. Just as a side note, why remove ByRef? Is bad practice? I presumed that when passing values from one sub routine to another then it would require a reference? Moving onto trendlines now, and graph interactivity - which i though would/will be the hard bit! Thanks
  2. H

    Linear Axis Scale

    So the answer was that the arrays need to be converted from string arrays to double, and the points need to be added via DatabindingXY. I am so glad that this problem is finally dealt with. And i hope this helps someone in the future. Thanks, #Hero
  3. H

    Linear Axis Scale

    Okay in that case, i guess we are agreed that there is no reason why this shouldnt work. I will have a double check that no other process it affecting during runtime. EDIT: Have checked and there simply isnt anything related to any kind of chart control at all in my code except the code above...
  4. H

    Linear Axis Scale

    Of course, because it already existed. I simply commented that line out so that it was adding points to the already existing 'series1'
  5. H

    Linear Axis Scale

    Yes, no luck.
  6. H

    Linear Axis Scale

    I just dont understand it, using that code or any other code to the same effect, the chart just seems to flat out ignore any parameters i tell it to set for the xaxis. This is such a simple concept i have no idea why its being such a pain. Also set .isvalueshownaslabel = false and...
  7. H

    Linear Axis Scale

    Okay well it definitely is possible apparently to create a non linear axis... which is what is frustrating me... http://i.imgur.com/tNWPFLT.png Here is the code: Private Sub CreateChart(ByRef XAxisValues() As String, YAxisValues() As String, iarrayindex As Integer) Dim i As Integer, x...
  8. H

    Linear Axis Scale

    Unless i am missing something, why does the scale have to be logarithmic? if i want an x axis that goes 0 1 2 3 4 5 , but data points with an x value of 2.35 and 3.11, then why shouldnt i be able to do that? Also it prints a giant red cross on the chart if i enable that option.
  9. H

    Linear Axis Scale

    If it makes it any clearer, as a last resort, i basically want to make the axis independent of the data
  10. H

    Linear Axis Scale

    Hi, First off, apologies if this is meant to be in the graphics parts of the forum- let me know and i will move it. Anyway, i am creating a VB chart in a windows form, and basically no matter how hard i look, i cant find any code anywhere that allows me to force the x-axis scale to be linear...
  11. H

    Copy excel data to datagrid

    For those interested in this i managed to come up with code that does exactly stated, as described above. And for people wanting to use the microsoft copy and paste feature for other purposes, the copy function saves the values (excel data in my case) as a string onto the clipboard. In order to...
  12. H

    Copy excel data to datagrid

    Hi, i have a windows form with a datagrid, and i want the user to be able to copy and paste the data i am going to perform calculations on, into the grid in a certain column. For simpilicity, we can assume that they have copied the correct numerical values to the clipboard from excel, and they...
  13. H

    Question Filtering and Copying Excel Data using a Windows Form

    Hey, First off just like to point out this is my first post in this forum, so if its in the wrong place or anything please let me know - its not intentional :encouragement: Also, if you could just comment/ help with the specific issue rather than the background process that would be great...
Back
Top