Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 21st 06, 05:04 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 124
Default Use values instead of labels on X-axis in Area/Stacked Area Charts

When building a stacked area chart, independent of how the linked cells are
formatted, the chart uses the x-axis values as simple text labels. Since my
values are not equally spaced, this distorts the plot, and I have not found
any method through the help menus to change this formatting.

Any help would be greatly appreciated.

  #2   Report Post  
Old November 21st 06, 05:14 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Use values instead of labels on X-axis in Area/Stacked Area Charts

This technique might give you some ideas:

http://pubs.logicalexpressions.com/P...cle.asp?ID=508

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ryan" wrote in message
...
When building a stacked area chart, independent of how the linked cells
are
formatted, the chart uses the x-axis values as simple text labels. Since
my
values are not equally spaced, this distorts the plot, and I have not
found
any method through the help menus to change this formatting.

Any help would be greatly appreciated.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Charts X Axis values as dd/mm/yy hh:mm PeterS Charts and Charting in Excel 1 May 30th 06 03:09 PM
Labels & Values for Pie Charts sumitk Excel Discussion (Misc queries) 0 May 17th 06 10:45 PM
Y Axis values on bar charts mr_teacher Charts and Charting in Excel 1 May 12th 06 10:34 AM
Hiding Values Below Z Axis Minimum Value on Axis Charts TryingToExcel Charts and Charting in Excel 1 February 18th 05 04:55 AM
How do I move the Category Axis labels outside of the Plot Area? Brian Shoun Charts and Charting in Excel 1 January 7th 05 06:42 PM


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017