I want to enter raw data into excel plots just by typing the numbers 20.35,20.35 but excel doesn't allow this by default and only accepts data from cell references. How to do it my way?


Yes, it is possible to assign data other than Cell references to plot the Chart in Excel.

How it works:

  • From Insert Tab click any of the Chart type Icons.
  • You get blank Chart plot area.

enter image description here

  • Now, click Select Data from the menu.
  • From the poped up dialogue click Add button.

enter image description here

  • Fill Data as shown above in Sceen Shot.


Note, Series Name is an optional.

  • Finish with Ok.

Now you get the Chart.

enter image description here

N.B. This method has been used with Excel 2013 & 2016.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy