Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
pete
185
Graph for large dataset
posted

I am using BarChart3D and it seems that when there is more than 10/15 rows of data, I don't get a graph.

Following query on Northwind returns 89 rows and graph generated is pic 1 (below)

 

select  a.customerID as 'Customer', count(b.OrderID) as 'Order Count'
FROM
Customers a, Orders b
WHERE a.CustomerID = b.CustomerID
GROUP BY a.CustomerID
ORDER BY 2 DESC

Same query with Top 10 selected and graph generated is pic 2 (below)

select Top 10 a.customerID as 'Customer', count(b.OrderID) as 'Order Count'
FROM
Customers a, Orders b
WHERE a.CustomerID = b.CustomerID
GROUP BY a.CustomerID
ORDER BY 2 DESC 

Question - what setting do I need to change so that I get graph no matter how many rows are there?

 

 

 

  • 28496
    Offline posted

    there is no setting that does what you're asking.  i recommend one of the following solutions:

    1: place the chart in a panel with AutoScroll = true and set the chart's Height to a very large number e.g. 2000.

    or

    2: use a 2D bar chart and enable the scrollbar on the Y-axis.