{"id":"https://openalex.org/W2390721998","doi":"https://doi.org/10.1007/978-1-4302-4945-0_3","title":"The Principles of Data Visualization in Microsoft Excel","display_name":"The Principles of Data Visualization in Microsoft Excel","publication_year":2015,"publication_date":"2015-01-01","ids":{"openalex":"https://openalex.org/W2390721998","doi":"https://doi.org/10.1007/978-1-4302-4945-0_3","mag":"2390721998"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-4945-0_3","doi":"https://doi.org/10.1007/978-1-4302-4945-0_3","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-4945-0_3","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Dashboards for Excel","raw_type":"book-chapter"},"volume":{"id":"https://openalex.org/W2496464065","display_name":"Dashboards for Excel"},"type":"book-chapter","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5023705191","display_name":"Jordan Goldmeier","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jordan Goldmeier","raw_affiliation_strings":["OH, US"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"OH, US","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5028430611","display_name":"Purnachandra Duggirala","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Purnachandra Duggirala","raw_affiliation_strings":["OH, US"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"OH, US","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.171875,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"35","last_page":"53"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9940999746322632,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9940999746322632,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.0052999998442828655,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.00019999999494757503,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-visualization","display_name":"data visualization","score":0.9950000047683716},{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft Excel","score":0.9700000286102295},{"id":"https://openalex.org/keywords/charts","display_name":"charts","score":0.875},{"id":"https://openalex.org/keywords/best-practices","display_name":"best practices","score":0.7730000019073486},{"id":"https://openalex.org/keywords/pie-charts","display_name":"pie charts","score":0.9190000295639038},{"id":"https://openalex.org/keywords/spreadsheets","display_name":"spreadsheet software","score":0.5419999957084656},{"id":"https://openalex.org/keywords/chart-selection","display_name":"chart selection","score":0.3440000116825104}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6870540976524353},{"id":"https://openalex.org/C3019730874","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Microsoft excel","level":2,"score":0.6438024640083313},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.5756895542144775},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.4831385314464569},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.47166359424591064},{"id":"https://openalex.org/C61122496","wikidata":"https://www.wikidata.org/wiki/Q1124595","display_name":"Bar chart","level":2,"score":0.41835111379623413},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.34847190976142883},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.19295617938041687},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4302-4945-0_3","doi":"https://doi.org/10.1007/978-1-4302-4945-0_3","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-4945-0_3","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Dashboards for Excel","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4361838472","https://openalex.org/W2356215168","https://openalex.org/W4376116863","https://openalex.org/W4232942069","https://openalex.org/W4361838914","https://openalex.org/W4242855903","https://openalex.org/W2341395806","https://openalex.org/W2749956520","https://openalex.org/W4361838307","https://openalex.org/W7223601228"],"abstract_inverted_index":{"To":[0],"my":[1],"knowledge,":[2],"there":[3,40],"is":[4,41,120],"little":[5],"in":[6],"the":[7,60,66,75,95,116,123,129],"current":[8],"spreadsheet":[9],"literature":[10],"discussing":[11],"best":[12],"practices":[13],"with":[14],"data":[15,98],"visualization.":[16],"There":[17],"are":[18,54,63],"many":[19],"books":[20],"on":[21,51],"how":[22,81],"to":[23,72,82,90],"create":[24,83],"pie":[25],"charts,":[26,28],"three-dimensional":[27],"and":[29,97,113,122],"spider-charts,":[30],"but":[31],"few":[32],"discuss":[33],"why":[34,49],"for":[35,93],"each":[36],"of":[37,65,88],"these":[38,52,84,100],"charts":[39,62,85,101],"always":[42],"a":[43],"better":[44],"choice":[45],"available.":[46],"I":[47],"see":[48],"tutorials":[50],"subjects":[53],"at":[55],"first":[56],"appealing;":[57],"after":[58],"all,":[59],"former":[61],"part":[64],"Excel":[67,78],"core":[68],"package":[69],"library.":[70],"Therefore,":[71],"perhaps":[73],"pass":[74],"Expert":[76],"Microsoft":[77],"certification,":[79],"knowing":[80],"may":[86,125],"be":[87,126],"service":[89],"you.":[91],"However,":[92],"us,":[94],"developers":[96],"consumers,":[99],"do":[102],"more":[103],"harm":[104],"than":[105],"good.":[106],"These":[107],"keywords":[108,124],"were":[109],"added":[110],"by":[111,115],"machine":[112],"not":[114],"authors.":[117],"This":[118],"process":[119],"experimental":[121],"updated":[127],"as":[128],"learning":[130],"algorithm":[131],"improves.":[132]},"counts_by_year":[],"updated_date":"2026-10-10T09:11:00.788812","created_date":"2016-06-24T00:00:00"}