when to use a dotted line
post illustrating the step-by-step on how to achieve in Excel if that’s of interest). Since we're on formatting each individual data point (for example if you are working in Excel, you would click once to Excel Downloads the line). I imagine you could use a similar approach in other tools. You can download the Excel
axis vs data labels
Excel Downloads pay attention? Let the answers to these questions guide your thoughtful design. If interested, you can download the Excel file with the above graphs.
numbers of different magnitudes
that assumption!)—I might do something like the following: The Excel file with the preceding graphs Excel Downloads
visualizing change via slopegraph
the slopegraph can be an extremely effective visual. If interested, you can download the Excel file . However, that’s time well invested if it means your audience clearly understands the story. Here’s a handy Excel template to get you started. Excel Downloads
novel vs. the boring old bar chart
, you can also download the Excel file with the above graphs. Excel Downloads
area graph to highlight a line
Excel Downloads comment with your thoughts! You can download the Excel file with the above visuals.
how we position and what we compare
and arrange the data—can make those comparisons easy or difficult. Aim to make it easy. The Excel Excel Downloads this overall layout: each cohort is a single line graph in Excel, where I’ve formatted it so there
our tools don't know the story
life. If interested, you can download the Excel file with the above graphs. Want more on story? Check Excel Downloads universal. No matter if you’re using Excel, Tableau, PowerBI, R, SAS, or something else, the tools
a tale about opportunity
Excel Downloads understand something new. If interested, you can download the Excel file with the above visuals. 10
supercategory axis labels in Excel
should be—aim for horizontal text whenever possible. In Excel, there is a quick trick to fix this. I get -axis. If it would be helpful, you can download the Excel file. Would it be helpful to see more supercategory axis labels in Excel Excel Downloads I have a super quick tip to share today for those reading who work in Excel. I see graphs regularly Excel "how to" posts like this? Let me know if there are specific topics or questions of interest that the same process with monthly data. In the Excel spreadsheet, the data graphed above looks like this
an alternative to treemaps
at the graphs, you can download the accompanying Excel file. What do you think? Are there are increasingly being included in most data visualization tools (including the latest Excel 2016 Excel Downloads
visualizing uncertainty
markers to help visually reinforce the uncertainty. In Excel, there are two potential ways to achieve tactics for creating in Excel. The client’s original visual looked similar to the one below. It shows to the audience, we’ll deal with that momentarily. The brute-force Excel method to adding this grey Excel Downloads Brute Force Excel accompanying Excel file to see how I accomplished this. But the visual is not yet complete. We
putting graph elements in cells directly
to see what I'm talking about, below is what the visual looks like if I show the gridlines in Excel Today's short post focuses on an Excel tip that I find myself using frequently and I get asked about a ton. While I focus on Excel here, I imagine the same could apply when working in any spreadsheet of the graph directly, rather they are in individual cells in Excel. In this particular graph, the Excel Downloads this for additional formatting flexibility. In Excel, you can only apply a single format to axis
tactical tip: embedding a vertical reference line in Excel
where you want the reference line. I’m using Excel 2016 and you can download the accompanying file iterations. After some research and playing around in Excel, I’ve devised one method for achieving this Excel Downloads line and the label that describes it. You can download the Excel file to see the behind-the-scenes of . Created in Excel, the line was physically drawn on the graph with the Shape Illustrator. While this tactical tip: embedding a vertical reference line in Excel Brute Force Excel Today's post is a step-by-step Excel “how-to” inspired by a reader question we received following a
more Americans are tying the knot
than they are. In fact, when I first plotted this data in Excel, the program automatically zoomed graph that's layered over the first - this is a true example of brute-force-Excel) plotted only the where you want them to focus their attention. For those who are interested, the Excel file containing the above makeovers can be downloaded here. Brute Force Excel
"animation" with power point
Excel and Power Point, together with QuickTime Player. My approach was to build the final graph in Excel, and then make a number of copies of it, eliminating some of the data elements from each so that off topic. Today, I want to show you how you can use Excel and Power Point together with some simple QuickTime Player to record my computer screen and voice. Here's my resulting video: The Excel file Brute Force Excel
plotting a value within a range
line, and no shadow (I will never understand why Excel adds a shadow in the first place!). STEP 3: Plot I often refer to my method of creating graphs as "brute force Excel," meaning that you can make in this post can be considered a prime example of brute force Excel, where I walk through the steps almost anything work in Excel, but it sometimes means getting a little creative. The method described next challenge was how to create this visual in Excel. I'll take you through how I did this. The in this post can be considered a prime example of brute force Excel. This example was taken from a Brute Force Excel
slopegraph template
see whether one will work given the specifics of your data), you can download the Excel template I created here (screenshot below). Brute Force Excel
how to do it in Excel
comes to the graphs, how do you actually make them look like that? I'm not Excel-savvy...help! Let me much everything I do is in Excel. I like to refer to it as "brute-force" Excel, because in many cases ; it's from the FlowingData Challenge earlier this year (original blog post here). The full Excel those who question their Excel expertise to some of my tricks. The following example may look familiar take a few minutes to walk step-by-step through an example to expose those who question their Excel expertise to some of my tricks. to the graphs, how do you actually make them look like that? I'm not Excel-savvy...help! Pretty file can be downloaded here. What you require most to get from Excel's original graph to the one you how to do it in Excel
no more excuses for bad simple charts: here's a template
. There are those little things that I do every single time I use Excel: change the colors, remove the downloading). Perhaps in addition to eliminating some of my personal Excel time-suck, this will help alleviate If you're using Excel to try to tell a story with data, plotting the data in this application ...this all sums up to a big time save to start from a place that is different than Excel's defaults. So proud to present. I've often given others the advice to create a template in Excel that has some of
See more