Jamie T

Members
  • Content count

    3
  • Joined

  • Last visited

About Jamie T

  • Rank
    Forum Newbie
  1. Plotting with varchar

    Thanks Arindam. The XML structure you've given me is a static XML page. I'm trying to plot dynamically from a database table. I've done the SQL and it is plotting with the base line (catag) values as numbers (1,2,3 etc), but if I change these values to words (bearings, motors etc) then it won't return data to plot. Any ideas what I'm doing wrong. I appreciate how frustrating it must be trying to guide people who don't know what they're doing but I've been struggling with this for 2 weeks now. Your help is much appreciated while I build an evaluation of your product. Jamie.
  2. Plotting with varchar

    Thanks for the quick response. I'm plotting from a database with MySql/PHP. My table looks similar to this: PartNumber catagory quantity 1 bearing 4 2 bearing 5 3 bearing 15 4 motor 2 5 motor 6 6 belt 2 7 belt 5 I want a simple graph to show total quantities for each catagory. I can do it if catagory was a number, but not as a word. Can you help? Thanks. Jamie.
  3. Plotting with varchar

    Hello All. I'm trying to plot my inventory ..... stocktype (eg. Bearings, Motors etc) against quantity (from the same table), but the chart won't plot. I think it's because the chart only works with numbers. Is this true? So how can I plot how many bearings and motors I have without creating another table etc.? Thanks. Jamie.