Incloent Secondary Axis a l'Excel Chart Make it attainable to precisely characterize combined sort d'information al Bar Chart Format. Heu de tenir en compte que podeu afegir Secondary Axis in Excel.
Add Secondary Axis in Excel Chart
Amb l'event check out the Knowledge Set as llistat under, you'll discover that Month-to-month Gross sales measured in {Dollars}, whereas the Revenue earned is measured in proportion (%).
Per a una d'aquestes combinacions de coneixements s'utilitza el create a Bar Chart in Excel, està fent yourself s Chart que no és característica de la informació.
In above Chart, els blue bars characterize Mont-to-month Gross sales ($) and the tiny Orange bars characterize Revenue Margins (%).
Whereas aquest Chart does present truthful illustration of Month-to-month Gross sals figures, it hardly offers any helpful details sobre Month-to-month Income earned.
Aquesta deficiència en l'Excel Chart s'ha fet simplement inclosa a Secondary Axis per precisar la característica d'un representiment nou (Revenue margin on this case).
So, allow us togo forward and try two totally different strategies so as to add Secondary Axis in a Bar Chart.
1. Add Secondary Axis Utilitzar Really useful Charts Possibility in Excel
Només una estratègia per a Add Secondary Axis per a Chart a l'Excel és per utilitzar les Realment useful Charts característiques obtainable per a l'Excel 2013 i variacions variades.
1. triï el Knowledge Set > click on on the Insereix pestanya> Really useful Charts possibility within the 'Charts' part.
2. Dins de la Insereix gràfic dialog field, undergo advisable Charts within the left pane and choose the Gràfic with a Secondary Axis.
3. Feu clic a sobre OK per acabar el diàleg field and you'll find yourself with l'Excel Chart havent main and secondary axis.
Aix you mai see in above picture, including a Secondary Axis has led to a greater illustration of each Month-to-month Gross sales and Revenue Margins.
2. Manually Add Secondary Axis to Chart in Excel
If you don't discover a Chart with secondary axis, you mai manually add a secondary axis by following the steps under.
1. triï el Knowledge Set > click on on the Insereix tab and choose 2-D Clustered Column Chart possibility.
2. Within the inserted Chart, choose the Minor bars (Revenue bars). If the minor bars are tiny, choose the Main or Bigger bars (Gross sals Bars) and hit the Tecla Tabulador.
3. After deciding on the Minor Bars, feu clic amb I tria Format Knowledge Sequence possibilitat.
4. Within the right-pane that seems, choose the Eix secundari possibilitat.
Aquest can add a secondary axis en el present bar chart i vostè find yourself with 2 overlapping bars.
5. Ara, feu clic amb el botó dret a Revenue margin bar I tria Change Sequence Chart Sort possibilitat.
6. In Change Chart Sort diàleg field, change the Revenue Margin Chart sort to Line with Markers.
7. Feu clic a sobre OK to save lots of the modifications.
Nou hau Bar Chart amb Major Axis representing Gross sales Knowledge ($) i Secondary Axis representing Revenue Margins (%).
Right way to Take away Secondary Axis from an Excel Chart?
All that's required per fer secondary axis a l'Excel Bar Chart és a picar la secondary axis i press the Delete key.
1. triï el Eix secundari fent-hi clic.
2. Premeu el botó Suprimeix la clau on the keyboard of your pc
Alternately, you can too right-click on the secondary axis and click on on the Esborrar possibility within the contextual menu.
- Right way to Create Gantt Chart in Excel
- Right way to Create Waterfall Chart in Excel
Em dic Javier Chirinos i sóc un apassionat de la tecnologia. Des que tinc ús de raó em vaig aficionar als ordinadors i als videojocs i aquesta afició va acabar en una feina.
Porto més de 15 anys publicant sobre tecnologia i gadgets a Internet, especialment a mundobytes.com
També sóc expert en comunicació i màrqueting en línia i tinc coneixements en desenvolupament a WordPress.