Friday, September 23, 2016

[Solution] Creating chart with only info included in spreadsheet

Creating chart with only info included in spreadsheet

Is there a way that I can create a chart in MS Excel 2007 that only has the data that I entered? For example, when I create a table with dates, Excel automatically enters in the missing values which I did not enter nor want.
 
For example:
 
1.
I create a table with the following information:


Average Precipitation (inches)

        Town 1
        Town 2

1-Jan
10
69

4-Jan
5
53

6-Jan
208
76

10-Jan
145
74

 
2.
I select all of the cells, go to the Insert tab and select one of the available choices (e.g.
line) .
When I do, I get a chart that includes every value from 1-Jan through 9-Jan, including ones that I did not provide (e.g.
2-Jan, 3-Jan, 7-Jan, 08-Jan).
There must be a way that I can create a chart without those extra values.

 
Any help would be greatly appreciated.
 
Thanks!

Anwsers to the Problem Creating chart with only info included in spreadsheet

Download Error Fixer for Free Now

You're on the right track with a Line graph (rather than x-y scatter).  In your line graph, right click on the X-axis and Format Axis.  In the Axis Options, change the Axis type to Text.
Did that do it?
Cheers
Rich

Check memory problems

Memory management issues can also cause a BSOD in Windows 7. Thankfully, Windows 7 has a Memory Management Diagnostic tool that detects and solves problems related to system memory.

  1. Click on the Start button on the Taskbar.
  2. Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
  3. Click on Windows Memory Diagnostic Tool (in the search results).
  4. Click on "Restart now and check for problems (Recommended)".
  5. The system will restart, and you need to follow the instructions given on the screen.

Another Safe way to Repair the Problem: Creating chart with only info included in spreadsheet:

How to Fix Creating chart with only info included in spreadsheet with SmartPCFixer?

1. Download Error Fixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.


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: [Solution] Copy only one page of a 4 page document,Solution to Problem: Creating a Word Document based on a page layout design,How to Fix Problem - cursor disappears while typing. Have to reposition cursor when it reappears?,Troubleshooter of Error: couldn't send email as attachment in merge mail,[Solved] CPUZ Mulitplier Win 7 x64 Ultimate Vs. Vista x64 Ultimate,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