เพื่อมุ่งให้เกิดคุณภาพจากการอบรมสูงสุด Excel Expert Training ให้การอบรม Excel กลุ่มเล็กๆ ไม่เกิน 6 คนทุกคนสามารถเรียนรู้ Excel อย่างใกล้ชิด จะมาคนเดียวหรือมาเป็นกลุ่มแล้วนัดวันอบรมแบบส่วนตัวก็ได้ ผู้เข้าอบรมทุกคนสามารถติดตามเนื้อหาที่อบรมได้อย่างชัดเจนจากจอภาพด้านหน้าของตัวเอง
Results 1 to 3 of 3

Thread: ขอรบกวนสอบถามเรื่องกราฟใน excel

  1. #1
    sutin
    Guest

    ขอรบกวนสอบถามเรื่องกราฟใน excel

    โจทย์แข่งขัน เกี่ยวกับ excel ให้สร้างกราฟ
    แข่งขัน วันที่ 16 พฤจิกายน 2555 ณ ประเทศ อินโนนีเซีย
    โดยนักศึกษาไทย
    รบกวนข้อคำแนะนำว่าจะใช้ฟังกชันหรือสูตรที่ทำให้ได้ผลลัพธ์ ตามที่โจทย์ให้มาค่ะ
    ขอบคุณค่ะ
    Session 4 – Day 2 (Additional Test Project – A4)
    The Project Manager of Steve and Steph Consultants needs an additional project to monitor the spectators and help them with the report for each region.
    Deliverables
    ID Name Description
    A4.1 Spectators Charts Enable NSC® management to review the spectator graph based on the selection and the provided data.
    A4.2 Spectators Reports Enable NSC® staff to help generate the report to be send to each country football association
    A4.3 Replace Program Help NSC® staff to replace certain word / terminology in group of reports.

    A4.1 Spectators Charts (Spreadsheet)
    The management of ISIS, request for a simple monitoring system of the spectators’ number in every stadium for the match in simple spreadsheet design. In this case you are requested to create the template where the management can update the country, stadium, competition category, seat type and number of spectators to generate the graph of the spectators. The management has given some basic design that they required in the graph.
    This is the sample design drafted from the management.
    Attachment 11770
    · To simplify the result, you could limit the data into 10 lines and 12 columns.
    · Prepare a simple spreadsheet (like the sample in the picture, the name that user pick to use will not be mark). This data can be updated based on the reality of the competition, and the system is still capable to update the graph based on the updated information. The update is directly in the data, no special place to entry (except the color setting)
    · If we activate (click) one of the cell inside the data, it will select a range of data based on the active cell(s) for country and competition category (e.g. Spain & Quarter Final). And the active cell(s) will be also has different highlight.
    · To ensure the consistency color of the blocking area, prepare an area where user can define the seat type that will be used and the highlight color for selection and graph and also for selected cell(s). Here is a sample of setting for seat type and color
    Attachment 11771
    · For the data that is chosen (or selected), display and update the color for selected data and the chart based on it. Notice some requirement for the charts:
    o For the seat type, the user can select from a drop down list, based on the seat type that have been entered in the setting area.
    o The color of each bar in the chart and the color of the selected cell are in line with the color chosen in the setting area.
    o The active cell (which is highlighted), will also have the same highlight in the chart as was set by the user.
    o When the user select multiple cell that are cross more than one area, the graph will display assuming the region selection where the first selected cell start
    o When users select a cell in an area which has no seat type (data or the type has been change or updated or seat type happened to be deleted), give special treatment in the graph and the data (for example: highlight the data with black and will not display the graph).
    · If the user select of click one cell or area outside the data, the system will assume the closest cell in the data to the active cell is selected and will show the data according to it.
    · The label and title chart will also be updated according to selection.
    · Arrange the sample data to show your prototype is working (if you are using formula to fill it in, convert it into fixed value). The data or the graph will be used for the report and checking for consistency will be easier if the data is consistent.


    Here are some other samples of graph treatment to easier understand what was requested by the management. The data provided in the view is just a sample. You can use a simple name.

    Overall view of the requested graph report when user select one cell and the color setting area is on the right side
    Attachment 11772
    ----------------------------------------------------------------------------------

    User can select the seat type based on the user set in the color setting.
    Attachment 11773
    ------------------------------------------

    Sample when multiple cells in one group is selected. The selected cells is also highlighted in group
    Attachment 11774
    ---------------------------

    When the selected cell is outside the data range, the nearest cell will be assume to be selected

    When user select multiple cells in the active data.

    When the user select multiple cell that are cross more than one area, the graph will display assuming the region selection where the first selected cell start

    ส่วน file ที่ทำไปบางส่วนแล้ว A4 excel.xlsx

  2. #2
    สมเกียรติ
    Guest
    ยากมากครับ

    ทำอย่างไรให้เซลล์เปลี่ยนสีได้เองเมื่อเลือกพื้นที่ตารางตรงนั้นๆแล้วทำให้แท่งกราฟเปลี่ยนสีตาม
    ถ้าไม่ใช้ VBA จะทำได้ด้วยหรือ

  3. #3
    วานิชย์
    Guest
    ลองดูตามตัวอย่างใน Link นี้ครับ


    http://www.excelhero.com/blog/2012/0...e-a-graph.html

    ตามตัวอย่างจะมี VBA อยู่นิดหน่อย แต่น่าสนใจดีครับ

    :smile:

Posting Permissions

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