Microsoft Office Forums Problem Formatting My Charts

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2019, 05:25 PM
skeezix skeezix is offline Problem Formatting My Charts Windows 10 Problem Formatting My Charts Office 97-2003
Advanced Beginner
Problem Formatting My Charts
 
Join Date: Jan 2019
Posts: 44
skeezix is on a distinguished road
Default Problem Formatting My Charts


I'm using Excel 2000. On worksheet 5 I clicked one of the dates, then clicked Format Axis. A Format Axis box appeared and I clicked Scale. I got what I wanted (see the first image). That's good. I can specify a start and a stop date for my chart.

In the same file but on worksheets 1 through 4, the Scale tab in the Format Axis box contains different parameters (see the second image), and I cannot set my start and stop dates. That's not good.

I've spent hours comparing the two worksheets, trying to figure this out, but have had no success. What do I need to do on worksheets 1 through 4 so that the Scale tab in the Format Axis box looks like the first image?
Attached Images
File Type: jpg Excel Chart 1.jpg (115.5 KB, 12 views)
File Type: jpg Excel Chart 2.jpg (157.4 KB, 12 views)
Reply With Quote
  #2  
Old 05-23-2019, 10:54 PM
ArviLaanemets ArviLaanemets is offline Problem Formatting My Charts Windows 8 Problem Formatting My Charts Office 2016
Expert
 
Join Date: May 2017
Posts: 448
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

I'm almost sure, in table the 2nd chart is based on the date is text string instead of date.

To check this,
a) make the date column wider, and remove any alignment. After that dates are aligned to right, texts to left.
b) simply change the date column format to general - dates are then numbers, texts remain same.
Reply With Quote
  #3  
Old 05-23-2019, 11:36 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Problem Formatting My Charts Windows 7 64bit Problem Formatting My Charts Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,383
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

@skeezix
In the future please post a sample sheet (go advanced manage attachments) so we can work on ti and avoid cluttering the thread with large images.
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #4  
Old 05-25-2019, 06:03 AM
skeezix skeezix is offline Problem Formatting My Charts Windows 10 Problem Formatting My Charts Office 97-2003
Advanced Beginner
Problem Formatting My Charts
 
Join Date: Jan 2019
Posts: 44
skeezix is on a distinguished road
Default

@Pecoflyer - I'll send a sample worksheet in the future. Thanks for letting me know, 'cause I don't particularly care for large images in posts either.


@ArviLaanemets - I looked at at the formatting of the date column and verified that there is no alignment. Also, seeing the dates as numbers doesn't work for me - I need to see the dates in the worksheet.


I've tried a lot of things but just cannot get a count of cells with data in a column if that column has text in it, so I'm giving up.
Reply With Quote
  #5  
Old 05-26-2019, 06:34 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Problem Formatting My Charts Windows 7 64bit Problem Formatting My Charts Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,383
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Quote:
I'll send a sample worksheet in the future. Thanks for letting me know, 'cause I don't particularly care for large images in posts either.
Please post a sample sheet for this post Thx
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #6  
Old 05-27-2019, 08:05 AM
skeezix skeezix is offline Problem Formatting My Charts Windows 10 Problem Formatting My Charts Office 97-2003
Advanced Beginner
Problem Formatting My Charts
 
Join Date: Jan 2019
Posts: 44
skeezix is on a distinguished road
Default

Hi Pecoflyer,
Thanks for your reply.
After a lot of searching I finally found the problem - in the Axes tab that in the Chart Options dialog box I had Category checked when I should have had Time-Scale checked.
Now I am but a little ...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Charts - series custom color problem Rhene Excel 0 08-02-2017 11:20 AM
After updating linked excel charts in publisher, all charts are moved effinglife Publisher 0 05-23-2017 02:27 AM
Formatting issues when updating linked Excel charts Becky808 Word 0 08-05-2015 03:38 AM
Charts - formatting dates in a data table - Excel 2013 IanGUK1 Excel 0 12-04-2014 01:44 AM
Charts formatting jakudo Drawing and Graphics 0 08-21-2010 02:56 AM


All times are GMT -7. The time now is 10:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft