While the YouTube video shows a clever technique, it has too many steps for my taste--especially if doing multiple charts.
I prefer to create the chart in Excel and do one of the following:
1. Copy Excel chart and paste chart into Illustrator. Keep the Excel formatting simple for best results. This is OK for a few charts.
2. This is my technique for dealing with lots of charts for print (typically using InDesign):
a. Create chart in Excel and save. Best if using RGB colors that fall within the CMYK range. Move chart to own worksheet;
b. Then save-as PDF. If the data updates;
c. Place in InDesign (or Illustrator). If the chart data updates, simple update Excel file, save-as PDF replacing the original one, and update in InDesign/AI.
d. Export/Save As to PDF leaving colors unchanged.
e. In Acrobat Pro, using the Print Production tools, convert colors to CMYK and RGB black to 100K.
... View more