• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

quick excel chart question

G

gotsmack

Diamond Member
I want to make a single line chart (timeline) spanning from 12/10/04-2/18/05 and then breaking up the line at different dates to represent different periods.

so far all I got was a single chart with a 0-100% scale. I want dates. How do I go about doing this?


thanks in advance

http://www.resung.com/stuff/timeline.GIF
 
Originally posted by: gotsmack
I want to make a single line chart (timeline) spanning from 12/10/04-2/18/05 and then breaking up the line at different dates to represent different periods.

so far all I got was a single chart with a 0-100% scale. I want dates. How do I go about doing this?


thanks in advance
Click to expand...

You going to need to use some visuals to describe what you want. Perhaps a scanned hand drawing?
 
Double-click the time axis and select the 'Number' tab. Choose 'Date' from the list, then select the format you want displayed on the axis. If you want, I can tell you how to display the relevant info for each date on the chart too.
 
Originally posted by: CycloWizard
Double-click the time axis and select the 'Number' tab. Choose 'Date' from the list, then select the format you want displayed on the axis. If you want, I can tell you how to display the relevant info for each date on the chart too.
Click to expand...

I tried that, but it just turned into 00-jan-00 and other random dates.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top