By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 913 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

help for chart

P: 3
Hello everybody,

I am a newbie to programming.
Folloing is my problem,

I am getting serial out put as ascii string codes containing particle size distribution .It contains 50 seperate values denoting frequancy distribution.I have stored those values as 50 different numeric fields. I want to plot scatterxy chart with x axis bearing field name at a equidistance while Y arm should contain field-data value for one recordset only.can anybody guideme ?

N.B. In excel I could get the desired result with smooth line scatter graph option after storing value in one column.

awaiting response
Dec 25 '07 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
It's always better to store fields like that in different rows.
When you have one row with 50 fields a (large) UNION query could be used to transform the data like:
Expand|Select|Wrap|Line Numbers
  1. select 1 as Sequence, field1 from table1
  2. UNION
  3. select 2 as Sequence, field2 from table1
  4. UNION
  5. select 3 as Sequence, field3 from table1
  6. UNION
  7. ... etc
  8.  
Getting the idea ?

Nic;o)
Dec 25 '07 #2

FishVal
Expert 2.5K+
P: 2,653
Hi, there.

First of all I would like to recommend you to read the article on Database Normalization and Table structures. If you'll still feel difficulties of how to implement general database rules in your project, then I'll be happy to give you some help.

Regards,
Fish
Dec 25 '07 #3

P: 3
Thanks to both of you ,

I shall follow your suggestions & get back soon.

jnd001
Dec 27 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.