+ Reply to Thread
Results 1 to 26 of 26

Excel data in graph

  1. #1
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Excel data in graph

    Hi,

    How to display data of excel in pie chart or some good looking bar chart format.

    Thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: Excel data in graph

    An easy way is to select the data you want to graph, click on the Insert tab of the ribbon, then you can choose a chart type from there.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    but it's not giving good looking graph.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,438

    Re: Excel data in graph

    So, what do you consider to be 'good looking'? We cannot see inside your head. If you want people's help, then be prepared to give more than cursory requirements.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Valued Forum Contributor PaulSP8's Avatar
    Join Date
    11-21-2017
    Location
    Chorley, England
    MS-Off Ver
    2013 & 2021
    Posts
    437

    Re: Excel data in graph

    "Good looking" is a bit subjective, what you consider "good looking" isn't necessarily what anyone here thinks is good looking and vice versa.

    Best advice would be to follow Pete_UKs advice and get the style of graph you want and then tweak it by right clicking different elements and then formatting them to your tastes.

  6. #6
    Registered User
    Join Date
    12-07-2018
    Location
    Nijkerk
    MS-Off Ver
    -
    Posts
    3

    Re: Excel data in graph

    Have you tried conditional formatting
    You can select multiple styles just as you like it

  7. #7
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Excel data in graph

    Also to be glib,
    "pie chart" and "good looking"
    are mutually exclusive.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  8. #8
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    For example attaching one sample excel then need to filter it based on all the columns in a pie chart or some
    good looking chart format then how to do it any idea please?

    Thanks
    Attached Files Attached Files
    Last edited by janho; 12-17-2018 at 08:16 AM.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,438

    Re: Excel data in graph

    You don't seem to understand our responses so far. 'Good looking' is entirely subjective, so we cannot possibly satisfy that part of your request without knowing what you think it means.

    What on Earth does this mean?

    For example attaching one sample excel then need to filter it based on all the columns in a pie chart
    Apart from anything else, a pie chart has wedges, not columns ...



    EDIT (having now seen your attachment): the chart in your workbook is a bar chart. I still have no idea what you are angling for - sorry.
    Last edited by AliGW; 12-17-2018 at 08:21 AM.

  10. #10
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    means how to represnt it in some good looking format like some one click on defect then be able to check count and data of other columns as soon as mouse is hovered on it,means some dashboard type format.

    Thanks

  11. #11
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    hope someone might have seen good looking dashboards so same good looking dashoard from this sample data in attached excel needs to be prepared either it's pier chart or some good looking dash board type graph like this.

    Thnaks

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,438

    Re: Excel data in graph

    I will repeat once again what I have said already:

    'Good looking' is entirely subjective, so we cannot possibly satisfy that part of your request without knowing what you think it means.
    Getting information on hover is not possible natively in Excel. You'd need VBA to achieve that, or import your data into a data visualiser such as Power BI.
    Last edited by AliGW; 12-17-2018 at 08:43 AM.

  13. #13
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    ya please us VBA for that but after using it should contain statics from all the columns in it.so that when we click any pie chart or on some graph we should get details easily by just click a mouse on that particular portion of data.

    thanks

  14. #14
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    All efforts VBA and graph,pie chart are to make it in a good re presentable format either through VBA or through Some graph.

    Thanks

  15. #15
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,438

    Re: Excel data in graph

    No, no, NO!!!!!

    This is not how it works.

    Firstly, you need to explicitly state what you want - ideally, mock it up manually. Tell us what you have tried, and what is not working as you would wish it to. Once you have done this, we can make suggestions.

    So far. you have given us a very vague indication of what you are after and you are expecting us to come up with a solution for you. If you want this work to be done for you, then you need to post in the commercial services section, where you can pay someone for their time, but you will still need to give a much clearer specification.

    This is a help forum, not a do-it-all-for-you forum.
    Do you understand?
    Last edited by AliGW; 12-17-2018 at 08:50 AM.

  16. #16
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    already told that need a good looking graph from this excel data either through graph or if could be done through any VBA script etc. anything is fine.But endresult should be a good looking graph.
    Senior excel experts could you please help accordingly for the same.

    Many Thanks.

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,438

    Re: Excel data in graph

    OK - I give up. It is not HELP you want, it's a ready-made solution. Buy yourself some credit and post in the commercial services section if you don't want to make any effort yourself.

    Good luck!

    By the way, I am one of this forum's senior members and a moderator. You would do well NOT to ignore what I am telling you,
    Last edited by AliGW; 12-17-2018 at 08:59 AM.

  18. #18
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    already made several efforts even tried system generated recommended graph but tha too is so messy that we can not read data from all columns clearly by just hovering mouse on it.

  19. #19
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    like someone might have seen good classification bar graphs,or pie charts ,dashboards..etc. how they represent data so similarly this needs to be done.

    thanks

  20. #20
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    more senior experts could you please help on this complex type issue please.

  21. #21
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    if not the excel graph experts than VBA experts might help on this complex type of issue please.

    Thanks

  22. #22
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,438

    Re: Excel data in graph

    STOP bumping the thread!!!

    It is not the complexity of the issue: the problem is your unwillingness to give the information requested and to take any active part in the resolution of the problem.

    Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

  23. #23
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    already told that data should be represented in good looking form based on column headings in a sample excel attached on this forum and even tried of system recommend graph that too is not giving good looking graph.

  24. #24
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    so expert advise is requested to achieve this complex type of requirement.

  25. #25
    Registered User
    Join Date
    12-14-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    21

    Re: Excel data in graph

    any updates in between please?

  26. #26
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,438

    Re: Excel data in graph

    You have been told not to bump the thread unless you have anything useful to add. Please do not do so again unless you have something useful to add or 24 hours have passed. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 08-27-2015, 01:54 AM
  2. Extending excel graph with new data
    By hityou123 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-29-2015, 04:43 AM
  3. Excel graph with Data Table
    By hityou123 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-10-2015, 08:36 PM
  4. [SOLVED] Grouping Data within Excel Graph
    By mowens74 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-03-2014, 06:25 AM
  5. Replies: 0
    Last Post: 10-03-2014, 07:51 AM
  6. get data outof the graph into excel
    By Loves in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-05-2014, 08:04 AM
  7. [SOLVED] How do I update my static line graph to allow a user to select which data to graph
    By capcon in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-31-2011, 10:22 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1