Excel - two graphs in one (side by side)

Question

I have two graphs in Excel, but I want to combine the diagrams into one graph. As you can see, I have reduced the size of the chart in graph1, and I want to move the chart in graph2to empty space ingraph1

Answer 1

I think there are many ways to do this mainly in excel, as jrichall showed, but if you want to use the excel add-in to create this double chart, you can try FunFun.

This allows you to encode javascript in excel, merging two diagrams into one is pretty easy in programming languages ​​like javascript.

, :

https://www.funfun.io/1/#/edit/5a3d0933b848f771fbcdec96

, Json , . "", javascript .

Chart.js , , ( "bar" "line"):

var barChart = new Chart(ctx, {
    type: "bar",
    data: {
      // x axis represented by labels
      labels: [1, 2, 3, 4, 5, 6],
        datasets: dataset
    },
    options: {
      legend: {
      display: false
    },
      scales: {
        yAxes: [
          {
            ticks: {
              min: 0,
              max: 10
            }
        }
        ]
      }
    },
    animation: false
});

Chart.js .

, , excel, URL- Funfun. :

css (.label).

: Im funfun

Answer 2

, . ? / ? , , , .

, , :

: Multi Chart 2

Answer 3

- , , , :

• Chart Tools
• " "
• Combo ( )
• .