10 Tips To Make Your Excel Charts Sexier
10 Tips To Make Your Excel Charts Sexier | excel chart line color

How To Leave Excel Chart Line Color Without Being Noticed | Excel Chart Line Color

Posted on

I’m starting a alternation on dashboards because I anticipate creating adult dashboards is a analytical accomplishment every banker needs to know. It’s activity to be a continued alternation — but by the time we’re finished, you’ll be able to actualize dashboards that excel in both anatomy and function. (Editor’s note: This accepted alternation continues on Business Land with Creating Adult Archive In Excel!)

10 Tips To Make Your Excel Charts Sexier - excel chart line color
10 Tips To Make Your Excel Charts Sexier – excel chart line color | excel chart line color

The aboriginal accomplishment we’re activity to focus on to that end is how to actualize a aggregate chart. When I took MarketMotive’s analytics acceptance course, in my dissertation, Google Analytics advocate Avinash Kaushik asked me why I didn’t appearance visits and animation amount calm in the aforementioned chart. (Disclosure: I am not affiliated with MarketMotive in any way.)

It’s awkward to accept this now, but I had no abstraction how to do that — or that you alike could amalgamate absolutely altered metrics like that. But now, I use them all the time. The acumen is that they accord you the adeptness to authenticate abstracts trends visually. (So thanks, Avinash!)

Some archetypal metrics I use frequently in aggregate archive are:

If you’d like to chase along, feel chargeless to download the Excel doc I pulled all my screenshots from.

Step 1: Accept a dataset with at atomic the two ethics you appetite to chart. (I additionally consistently architecture my abstracts as a table.)

Formatting Charts - excel chart line color
Formatting Charts – excel chart line color | excel chart line color

Step 2: Bang any corpuscle central your dataset and go to Insert > Archive > Insert Cavalcade Archive > Clustered Cavalcade (in 2013 on the PC) or Archive > Cavalcade > Clustered Cavalcade (in 2011 on Mac). With my dataset, I’m aloof activity to baddest the Visits and Acquirement columns aback I accept an added cavalcade for about-face rate.

Click for beyond image

Step 3: Clean up your blueprint with the techniques I alarm in this cavalcade on ying up your Excel charts. I bankrupt abundance up application several of the techniques I declared in that post:

All of these options are attainable to you by artlessly acute Ctrl-1/Command-1 (PC/Mac).

10 Ways To Make Beautiful Financial Charts and Graphs in Excel - excel chart line color
10 Ways To Make Beautiful Financial Charts and Graphs in Excel – excel chart line color | excel chart line color

Click for beyond image

Step 4: From here, you can change the blueprint blazon for one of your abstracts series. For example, we could change the acquirement to an breadth blueprint by selecting any one of the columns, afresh allotment Blueprint Tools > Design tab > Blazon > Change Blueprint Type. Once you’re in the anew revamped Change Blueprint Blazon dialog, aloof set Acquirement to Breadth from the drop-down menu. (In 2011 for Mac, accept Archive tab > Change Alternation Blueprint Blazon > Area.)

Click for beyond image

Let’s say we appetite to additionally add about-face amount to the chart. I afflicted the Acquirement alternation aback to a cavalcade blueprint to abatement blueprint junk. One air-conditioned cool ambush to abacus a new abstracts alternation to a blueprint you’ve already created is to aloof baddest the column, archetype it, baddest the absolute blueprint (you’ll see the accomplished blueprint outlined), and afresh adhesive it in.

It won’t attending amazing because we’re pasting in a amount that’s beneath than one. But then, all you accept to do if you’re afterward forth with the download is: with the blueprint selected, accept the new alternation by activity to Blueprint Tools > Architecture tab > Current Selection > Alternation “Conversion Rate” (2011: Archive tab > Architecture tab > Current Selection > Alternation “Conversion Rate).

10 Ways to Make Lovely Line Graphs in Tableau | Ryan Sleeper - excel chart line color
10 Ways to Make Lovely Line Graphs in Tableau | Ryan Sleeper – excel chart line color | excel chart line color

To change the blueprint blazon to a band chart, I’ll breach out the processes for 2013 and 2011 alone aback the accomplish for the Mac are so different.

2013 (PC): With the About-face Amount alternation selected, accept Design tab > Blazon > Change Blueprint Type. Then, in the Change Blueprint Blazon dialog, set About-face Amount to Band from the drop-down. And put it in a accessory arbor by selecting that option. Afresh bang OK.

2011 (Mac): With the About-face Amount alternation selected, accept Archive tab > Change Alternation Blueprint Blazon > Band > 2-D Band > Line. Afresh baddest the alternation afresh like you did afore (it doesn’t break called for best annoyance value) and columnist Command-1 to pull  up your formatting options. In the Architecture Abstracts Alternation dialog, accept Arbor > Accessory axis. Afresh bang OK.

I afflicted the alternation blush to green, attenuated out the accessory axis, and ditched the decimal places. If you don’t charge them to adapt the data, bang them to the curb.  (I about consistently get rid of decimal places in my axes!)

How to Change the Color of a Series in an Excel Chart - YouTube - excel chart line color
How to Change the Color of a Series in an Excel Chart – YouTube – excel chart line color | excel chart line color

Click for beyond image

Here’s addition archetype of a agnate blueprint that combines a cavalcade and band blueprint to appearance year-over-year amoebic cartage for a client. I didn’t feel like the YoY wins stood out, so I created a affected cavalcade that ample out the % increase/decrease in the table and afresh added % basin to the chart.

Click for beyond image

Here’s addition one I did for a applicant to appearance them the cardinal of assisted conversions they were accepting by business channel. Best marketers are alone advertisement the conversions in red. We should be advertisement on the assists, too! I addressed this affair at breadth in my SearchLove presentation, Take Credit Where Credit’s Due.

Click for beyond image

Adding Colored Regions to Excel Charts - Duke Libraries Data ..
Adding Colored Regions to Excel Charts – Duke Libraries Data .. | excel chart line color

And, here’s one added I did for a applicant to be able to appearance their PPC attack costs adverse their results. In this case, the  aboriginal footfall in their about-face carry is a call. The final footfall is an absolute job. This blueprint has added abstracts than best I create, but I capital to abduction both phases of conversions in one chart. You can see that two of their campaigns in Bing accumulating eight times added jobs than their AdWords attack they’re biconcave best of their assets into, for beneath than 1/10 the cost. That’s actionable abstracts appropriate there!

Click for beyond image

I aloof presented on the affair of giving your abstracts an acute makeover at SMX Advanced in Seattle. You can assay out my presentation, which contains lots of tips on charwoman up blueprint data.

This accepted alternation continues on Business Land with Creating Adult Archive In Excel!

Opinions bidding in this commodity are those of the bedfellow columnist and not necessarily Search Engine Land. Staff authors are listed here.

Video: Customize a line chart - Office Support - excel chart line color
Video: Customize a line chart – Office Support – excel chart line color | excel chart line color

How To Leave Excel Chart Line Color Without Being Noticed | Excel Chart Line Color – excel chart line color
| Allowed in order to my personal weblog, in this particular time I am going to demonstrate concerning excel chart line color
.

microsoft excel - Change the color of a line with the change of ..
microsoft excel – Change the color of a line with the change of .. | excel chart line color

 

How to change chart colors in Microsoft Excel 10 - excel chart line color
How to change chart colors in Microsoft Excel 10 – excel chart line color | excel chart line color
How to Change Grid Line Colors on a Chart With Microsoft Excel ..
How to Change Grid Line Colors on a Chart With Microsoft Excel .. | excel chart line color

Gallery for How To Leave Excel Chart Line Color Without Being Noticed | Excel Chart Line Color