Friday, September 23, 2016

Creating a chart [Solved]

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.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed


Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: How to Resolve - Connection property Not changing on linked table?,Troubleshooting:Copy a combo box Error,How to Fix - Conting duplicate values using COUNTIF?,How to Fix Error - Copy to end of list?,How to Fix Error - Cursor disappears from active window - Windows 7?,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly

No comments:

Post a Comment