Color bands in bar charts in Microsoft Excel 2010

Multi tool use
Multi tool use












2















Is it possible to obtain a bar chart like the one in this example:



example



(that is: I need to have vertical color bands to make "visually" group the bars for each horizontal axis' point.)



Any ideas?










share|improve this question





























    2















    Is it possible to obtain a bar chart like the one in this example:



    example



    (that is: I need to have vertical color bands to make "visually" group the bars for each horizontal axis' point.)



    Any ideas?










    share|improve this question



























      2












      2








      2








      Is it possible to obtain a bar chart like the one in this example:



      example



      (that is: I need to have vertical color bands to make "visually" group the bars for each horizontal axis' point.)



      Any ideas?










      share|improve this question
















      Is it possible to obtain a bar chart like the one in this example:



      example



      (that is: I need to have vertical color bands to make "visually" group the bars for each horizontal axis' point.)



      Any ideas?







      microsoft-excel-2010 colors charts






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Apr 4 '17 at 19:46









      Stephen Rauch

      2,31581725




      2,31581725










      asked Oct 24 '13 at 13:56









      csparpacsparpa

      11113




      11113






















          1 Answer
          1






          active

          oldest

          votes


















          0














          Yes, you can do this by essentially creating one series of bars as your "background" then overlay the new series on top. It seems a bit odd, creating a data series purely for coloring but it works. It can be a bit tricky to visualize, but thankfully there's already a nice visual guide and detailed instructions for this here:



          http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html






          share|improve this answer























            Your Answer








            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "3"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f664795%2fcolor-bands-in-bar-charts-in-microsoft-excel-2010%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            Yes, you can do this by essentially creating one series of bars as your "background" then overlay the new series on top. It seems a bit odd, creating a data series purely for coloring but it works. It can be a bit tricky to visualize, but thankfully there's already a nice visual guide and detailed instructions for this here:



            http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html






            share|improve this answer




























              0














              Yes, you can do this by essentially creating one series of bars as your "background" then overlay the new series on top. It seems a bit odd, creating a data series purely for coloring but it works. It can be a bit tricky to visualize, but thankfully there's already a nice visual guide and detailed instructions for this here:



              http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html






              share|improve this answer


























                0












                0








                0







                Yes, you can do this by essentially creating one series of bars as your "background" then overlay the new series on top. It seems a bit odd, creating a data series purely for coloring but it works. It can be a bit tricky to visualize, but thankfully there's already a nice visual guide and detailed instructions for this here:



                http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html






                share|improve this answer













                Yes, you can do this by essentially creating one series of bars as your "background" then overlay the new series on top. It seems a bit odd, creating a data series purely for coloring but it works. It can be a bit tricky to visualize, but thankfully there's already a nice visual guide and detailed instructions for this here:



                http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Oct 24 '13 at 14:27









                Adam CAdam C

                2,3101525




                2,3101525






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Super User!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f664795%2fcolor-bands-in-bar-charts-in-microsoft-excel-2010%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    vs98hdrzg,QqZvmJ8 KxojAg xt4dLQED DaKvBTKIUB9vW3chVUrbmT3BGWO,3SDk7qB psZW,qkO6C,20dPpol g5,8LfrC
                    Cz bZmz3d7hYontZdtwquE2uI15c,Q U

                    Popular posts from this blog

                    Running commands remotely through an RDP connection

                    apt-mirror Malformed checksum error

                    pgfplots: How to draw a tangent graph below two others?