Steps to Speed Up Windows 10: Creating a chart [Solved]

Friday, September 23, 2016

Creating a chart

I need to create a chart using a range of cells that don't have data in them yet! The data is processed and displays in the cells as the month accumulates.
I need to have the chart sitting there waiting to begin showing the collected data but it doesn't appear to like have empty cells to begin with.
Does this make sense?
If I put data in there, create the bar graph, then delete the information, the graph stays there and appears quite happy, but it won't initially let me create it with no information in the cells to begin with.
The trouble is that my data range is full of formulas which I don't want to have to redo just to put some mock data in to make my graphs.
Can anyone help me out please?
Currently my data is displayed as follows:
DATE PERCENTAGE
4/01/10 100%
5/01/10 98%
etc

Keys to the Problem Creating a chart

Download SmartPCFixer to Fix It (Free)

Create a chart based on the first two or three data rows.
If you click on the data series, you'll see a formula like this in the formula bar:
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$3,Sheet1!$B$2:$B$3,1)
Edit this formula to include the entire range that you want to use eventually, e.g.
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$200,Sheet1!$B$2:$B$200,1)
Press Enter.

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.

Recommended Method to Fix the Problem: Creating a chart:

How to Fix Creating a chart with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer. Run it, and it will scan your computer. The junk files will be shown in the list.