Charts & Visualizing Data
165 TopicsOur eight best tutorials on Excel charts
Excel spreadsheets are all about numbers. But tons of numbers are often not the most effective way to communicate . That’s where charts come in handy. Charts can display numeric data in a graphical format, making it easy to understand large quantities of data and the relationships among data. If you want to learn about Excel charts, you’ve come to the right place. We’ve pulled together out best tutorials and articles on charts to get you started. https://blogs.office.com/2012/05/30/our-eight-best-tutorials-on-excel-charts/2KViews2likes6CommentsCreate advanced visualizations in Microsoft Excel - tips and tricks
An other great session from Scott Ruble about advanced visualizations in Exchel For the slides, take a look here https://techcommunity.microsoft.com/t5/Microsoft-Ignite-Content/THR1001-THR1001R-Create-advanced-visualizations-in-Microsoft/m-p/10445/highlight/true#M4522KViews2likes2CommentsMap Chart - Multiple Series
For filled map we naturally can't show multiple series at once, here is one of the ways how we may shift from one to another. I took first figures I found, internet usage in EU countries, and limit them by three countries: Next we 'unpivot' these data copying each series one under another, add one more column to the right (Category) with the name of the series, convert all together into the table (Ctrl+T) and insert Category slicer for it: Select first two columns of the table as above and insert the chart Since the chart will be placed against filtered rows not to forget to fix its position Desirably to have the name of filtered category as separate value. Usual approaches are to have filter value from PivotTable (but we don't need it) or use SUBTOTAL / AGGREGATE which can work with hided cells (or VBA of course). Details are out of this topic, let add array formula (that's not the only variant of it) =INDEX(tMaps[Category],MIN(IF(SUBTOTAL(3,OFFSET(C2,ROW(tMaps[Category])-ROW(C2),0)),ROW(tMaps[Category])-ROW(C2)+1))) where tMaps is the name of our table, into the cell F2 (will be under our chart). It returns first unfiltered value for Category column. Next hide Category column and design the Slicer a bit: To show selected series on the chart do Select Data for it and assign series name on cell F2 was defined above Practically that's all, result looks like39KViews2likes0CommentsTrying to make a chart template be the default chart
My favorite way to create perfect charts in one keystroke: 1. Create a chart with Alt+F1 and you get a clustered column chart. 2. Customize that chart to match your preferred chart style. 3. Right-click the chart and Save as Template. Give the template a name and save. 4. With the chart selected, choose Change Chart Type. Navigate to the Templates folder. Right-click your template and choose Set as Default Chart. 5. Click OK to close the dialog. In the future, you can select your data, press Alt+F1, and all of the settings from step 2 will be applied. It is a big time saver. I've featured this trick on my YouTube channel several times: https://www.youtube.com/watch?v=c8uokJztHTY Except: it was recently broken in Office 365 First Release channel. It still works in Excel 2013 and all past versions. Is this functionality being depracated on purpose? I understand you are moving to a new Ivy charting engine, but it is a great time-saver for people who routinely have to create the same type of charts. Thanks20KViews2likes1CommentHow can I stop Excel from changing the colors of my chart ?
I have a chart with past and forecasted figures for several series of data. I set the colors of each serie in order to have something nice and meaningful : 1 color per serie, dotted for forecast. Each time I filter my data to see a particular serie, Excel destroys my work to put back its automated layout which are ugly and meaningless. How can I prevent this ? I'm using excel professional plus 2013 Thanks a lot !Solved381KViews1like33CommentsError in Excel : All the charts are removed
When i open any excel file that contains charts, I am getting an error that there is problem found in the file and if i want to restore the file. If i say yes, it removes all my charts in the excel file. I could not add any new chart to the excel (also in complete new excel sheet). I tried repairing it and I tried reinstalling it. that does not solve the problem. I did not had this issue before. I have attached pictures regarding this Issue? How can i solve it? I am using Excel 2016 Thanks in advance.3.5KViews1like4Comments3D Maps Opening up Blank
Hello, I'm trying to use 3D Maps in Excel 2016 with a Microsoft-supplied sample file (Chicago Narcotics Sample File). When I click Insert -> 3D Map, I get the option to insert Tours, as expected. However, when I click on a tour and the separate 3D Map window opens, no map appears. Even stranger, when I mouse over a tour thumbnail on the left, that map goes blank. I'm having the same issue with other files. I have yet to see 3D Maps work properly with this installation. I have repaired and reinstalled Office Professional Plus 2016, but no change. I have set Internet Explorer to my default, and the Bing maps website there works fine. The Excel 2016 Bing Maps plugin also works fine. I have turned off my firewall temporarily, but that doesn't help. I'm running Windows 7, SP1. I'm up to date with my Windows Update installations. I've set Excel to "Run as Administrator" and tried a temporary Guest account, but that doesn't help either. The Office version is 1612. I do not have an Office 365 subscription, but I don't believe I need one for 3D Maps. What am I missing?6KViews1like4CommentsCreate a Map Chart
Great new artical about Maps You can use a Map Chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. Watch Doug from Office give a quick introduction to Map Charts: https://support.office.com/en-us/article/create-a-map-chart-f2cfed55-d622-42cd-8ec9-ec8a358b593b You can also find a sample file with Map data.2KViews1like0Comments