How to combine 2 or more charts and drive them with 1 data sheet in Datylon for Illustrator
Applies to: Datylon for Illustrator only
Combining 2 or more charts can have different purposes:
- You want to create one chart with 2 axes. The 2nd axis is than actually a 2nd chart.
- You want to combine 2 charts e.g. a trend line on top of a bar chart.
- You want to drive multiple charts with one datasheet so updating the data is more efficient.
Example: Line and bar chart with 2 vertical axes
In the below example, we will demonstrate all the above purposes in one single design by creating a line chart on top of a bar chart, with 2 axes, and driven by one data sheet.
Step by Step
- Create or open an Illustrator document.
- Create a Datylon chart and select Column chart from the chart library.
- Upload or create a data sheet with data for both bar chart and line chart. In this example, the data is structured in rows, with 2 columns. One row is for the bar chart, the second one is for the line chart. It can look like this:
- To make sure that the 2 charts will match, set the same Y-axis Min and Max Values for both charts. Go to Y Axis > Min Value & Max Value. For the given data we'll set Min Value to 0 and Max Value to 90.
- Now create the Line chart. To match the placement of bar chart and line, use the Illustrator menu Edit > Copy > Paste in Place. Now we have a copy of bar chart and a copy of the data sheet. Change chart type to line chart by clicking Select chart in the top right corner, select Line chart and then select type of line chart you want to use from the chart library.
- Next step is to assign the same Data sheet to this Line chart. To do this click Manage Data and then select the Data sheet that was used for Bar chart and click Select sheet. Then bind Y axis to the 2nd column, here Value 2.
- Make sure the margins for both charts are the same. Go to Styling > Positions and Margins and change if needed. You can select correct chart by using the Illustrator Layers tab.
- We can see that X-axis labels are not perfectly centered with the bars. To fix that we'll change Line chart X axis Outer padding to 35% (Styling > X Axis > Outer padding).
- Now let's turn on Y axis for Line chart, turn on axis labels (Styling > Y axis > Labels) and apply Flip Location property to put the labels to the right sight of the chart. Then apply same Min and Max Values that we applied for the Bar chart – 0 and 90.
- Then add some colors to line by going to Styling > Line > Stroke > Color. And we're done!