Monday, September 26, 2016

Fast Solution to Problem: Date insertion on chart in Excel 2007

Date insertion on chart in Excel 2007

I have a series of dates and numbers.  Dates (example only) are every Wednesday for 3 weeks, then a Thrusday, then a Wednesday, then a Friday, with 2nd column have a value.  When I try and chart the two on a simple bar chart, the chart assumes I want every
date for a Wednesday and autofills in dates with a value of zero until I reach the end of the string.  I cannot find any way for the chart to recognize the actual dates I selected for the chart and ignore the "auto date" issue unless I format the cells as
text and then select for the chart.
Is there a way (other than formatting as text) to tell the chart to ignore whatever auto-date feature it uses and ONLY use the dates (thereby cells) I select for the chart
Help appreciated - or direct me to proper forum to ask this question

Keys to the Problem Date insertion on chart in Excel 2007

Download SmartPCFixer for Free Now

In order to draw the chart accurately, Excel chooses a regular interval to display on the axis (seven days in this case) and offsets the bar from the label/tick mark appropriately.
The cleanest way to accomplish what you ask is to resize the chart, making it bigger until it is sufficiently large that Excel will automatically select one day as the preferred unit.  Making the chart its own sheet by right-clicking and selecting "Move
Chart" then selecting "New Sheet" is one way. 
An alternative is to decrease the text size.  Select the chart, then on the home tab in the font section, select  a smaller font size or use the A with down arrow button to decrease incrementally.  Hopefully there is a point where the text is still legible
but the axis units are where you want them.
You can also adjust the units by right-clicking on the axis and selecting 'Format Axis...'  then changing the major unit from auto to fixed and selecting one day as the preferred unit.  This will cause the labels to be very cramped if the chart area isn't
big enough or the font not small enough.
Another way is to format the axis as text as an alternative to making the data text.  This can be accomplished by right-clicking the axis, selecting "Format Axis" and under the Axis Type: heading (just below the part where you set the units) choose Text

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

  • Search "MSCONFIG" and Open.
  • Click on Boot Tab
  • Tick Safe Boot in Boot Option
  • Select Network.
  • Click Apply and OK.
  • Reboot your System.

Recommended Method to Repair the Problem: Date insertion on chart in Excel 2007:

How to Fix Date insertion on chart in Excel 2007 with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.

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

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.

Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 -,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v. driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error

No comments:

Post a Comment