Alpha Video Training
Results 1 to 4 of 4

Thread: Displaying Charts in Excel Via Export To Excel Function

  1. #1
    Member aal_fareed's Avatar
    Real Name
    Ahmed Shahin
    Join Date
    May 2010
    Location
    Saudi Arabia - Jeddah
    Posts
    387

    Post Displaying Charts in Excel Via Export To Excel Function

    Hello everyone ,
    i think this is not going to be easy question ,
    it is very important questions ,
    i have exported some data from a grid to excelsheet ,
    manually i am able to convert this data into charts using microsoft excel as you see in attached file .

    my question is , can i generate the chart directly from export function in the grid ?

    in other words , i want to have the chart on the attached file come along with the data when i export it from the grid to have better reading for data .
    again , the file is ready away from the application , i am doing it manually but i really wanted to be generated when i click on export from the grid
    you are all welcome to response as i badly need this for one of my running projects .

    please check attached file is the grid that contain data , and the grid that has data which have been converted to charts , chartsInExcel.PNGdataFromGrid.PNG
    To live anywhere in the world today and be against equality because of race or color is like living in Alaska and being against snow.”

    - William Faulkner

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Displaying Charts in Excel Via Export To Excel Function

    my question is , can i generate the chart directly from export function in the grid ?
    No.

    You can use Alpha ole methods to create the chart once the export is done.
    There can be only one.

  3. #3
    Member aal_fareed's Avatar
    Real Name
    Ahmed Shahin
    Join Date
    May 2010
    Location
    Saudi Arabia - Jeddah
    Posts
    387

    Default Re: Displaying Charts in Excel Via Export To Excel Function

    thanks , i guss you are the only certified who could answer that ,
    can you please explain more details how i can achieve the charts ?
    i already made excelsheet which have few cells reflecting to the bars in charts , so whenever i change these cells amount the bars will be adjusted based on the amount and so the average line ( see attached ) ... so , how can i use ole to achive that ?

    thanks for your response ,
    To live anywhere in the world today and be against equality because of race or color is like living in Alaska and being against snow.”

    - William Faulkner

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Displaying Charts in Excel Via Export To Excel Function

    Anything you can do in Excel can be coded in Alpha to tell Excel to do it. Check the code archive for some examples of using ole.
    There can be only one.

Similar Threads

  1. Grid - Export to Excel/Ascii - Image not displaying
    By Lesjml in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 07-26-2012, 07:06 PM
  2. Filling datasheet in excel template possible with export to excel FP?
    By cptutrecht in forum Application Server Version 10 - Web/Browser Applications
    Replies: 3
    Last Post: 04-28-2011, 08:23 AM
  3. Export to Excel - Export Hidden Fields not working
    By iviowa in forum Application Server Version 10 - Web/Browser Applications
    Replies: 5
    Last Post: 02-21-2011, 05:35 PM
  4. Import excel then export to excel
    By popellis in forum Alpha Five Version 8
    Replies: 4
    Last Post: 04-03-2008, 11:13 PM
  5. excel charts
    By WillieLucas in forum Alpha Five Version 5
    Replies: 0
    Last Post: 01-20-2003, 10:23 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •