Re: How do I change the orientation of a chart in Excel?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



In an XY chart the x-axis is always the horizontal one.
But you get to chose which are the x-values.
Put one set of data in column A, and another in B; the ones in A will be the
x-values when you make a chart.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Melissa" <Melissa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:695275EA-5438-4EB0-B535-BE4E6ACF10CA@xxxxxxxxxxxxxxxx
>I have a scatter plot that needs to be displayed vertically instead of
> horizontally - i.e. x-axis on the left side and y-axis across the top.
> how
> do I go about doing that???
> Thanks!
> Melissa


.



Relevant Pages

  • Re: Report with Multiple Scatter Charts
    ... > I want to produce a report that shows a scatter chart for each "Topic". ... The dots' X-values will be the Cat 1 rank. ...
    (microsoft.public.access.reports)
  • Re: Vertical Rule (TODAY marker) fails in XL2007
    ... All X-values are dates. ... advancing "today" rule across the chart. ... Multiple subtotals display on chart as scatter chart ...
    (microsoft.public.excel.charting)
  • Re: Chart Data
    ... Plot another series on the chart as a line, ... the same x-values and different y-values. ... > not necessarily correspond to the first data point. ... > starting position to perform calculations on the data? ...
    (microsoft.public.excel.programming)
  • Re: Line graph X-axis
    ... A common error - you are making a LINE chart when what is needed is an XY ... the x-values are real numbers. ... The chart that Excel is generating is shifting the X-axis out of scale ... whereas I would like a uniform scale on this ...
    (microsoft.public.excel.charting)
  • Re: multiple series of values graphed with indep. x values -possible?
    ... Use an XY chart, and format the series to have lines and markers. ... Peltier Technical Services ... I can only figure out how to make it so that there is only one series of x-values, with three y-values associated with each x-value. ...
    (microsoft.public.excel.charting)