Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default chart x-axis values appear as a series

The x-axis values do not appear on the x-axis but appear as another series on
the chart. How do I specify the x-axis values for a chart?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default chart x-axis values appear as a series

Existing chart:

Chart menu Source Data Series tab.

For a new chart, fix the data first. Put the X values in the first column
and Y values in the columns to the right. Put a label (series name) in the
row above the first row of data for each set of Y values, but keep the cell
atop the X values blank. Select the entire range, including X values, series
names, and blank cell, then start the chart wizard. The blank cell helps
Excel interpret the data range.

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


"rm5417" wrote in message
...
The x-axis values do not appear on the x-axis but appear as another series
on
the chart. How do I specify the x-axis values for a chart?



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
Different X-axis labels for different Series in same chart gmontgomery Charts and Charting in Excel 2 November 18th 06 05:17 AM
How to select numeric 'series axis' in a surface chart? S.Grossmann Charts and Charting in Excel 4 March 9th 06 02:58 PM
how to put x axis values in the chart instead of x axis labels Sinclair Charts and Charting in Excel 1 June 21st 05 11:04 AM
Chart -- How to chart 65536 values in 1 series? kilmaley11 About this forum 0 June 8th 05 11:19 AM
How do I change X-Axis values in a chart with 2 Y-Axis? ESGLCC Charts and Charting in Excel 1 May 4th 05 02:41 PM


All times are GMT +1. The time now is 12:46 PM.

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

About Us

"It's about Microsoft Excel"