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.
- Now, click Select Data from the menu.
- From the poped up dialogue click Add button.
Fill Data as shown above in Sceen Shot.
Note, Series Name is an optional.
- Finish with Ok.
Now you get the Chart.
N.B. This method has been used with Excel 2013 & 2016.