Multiple data in one chart?

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

Hi all,

I try to bring multiple data (hours and costs) in one chart but when I do
this the wizard says "You can only specify 1 field as data if you have both
an Axis and a Series field. Remove the extra data field(s) or remove either
the Axis or the Series field."
But it makes only sense with the Axis and Series field.

So where is the problem?

Thanks for help!
Marc
.

Relevant Pages

  • Problem with axis limits/range when using griddata
    ... I'm trying to plot a 3D graph using griddata but don't know ... how to specify the scale/range of the axis. ... The same problem goes for the y axis. ...
    (comp.soft-sys.matlab)
  • Re: Copy chart from Excel to Powerpoint
    ... The chart must be shrinking in PowerPoint, so the charting engine wants to use fewer axis ticks. ... If you specify all axis parameters, ... Peltier Technical Services ...
    (microsoft.public.excel.charting)
  • Re: How to use MSExcel to plot Column A against Col B?
    ... If your x axis points are 1,2,3....n then you do not need the first column of data, which is confusing the wizard, as it will automatically create those categories for you. ... It will if you create a xy-scatter chart rather than a line chart. ... column as x axis values/categories and the second column as y values. ...
    (microsoft.public.excel)
  • Re: Just want a plain graph -- heeeeelp!
    ... choose thy type 'X/Y scatter' ... finish the wizard / format too your needs ... > x axis and one is supposed to be the y axis. ...
    (microsoft.public.excel.charting)
  • Re: Copy chart from Excel to Powerpoint
    ... you specify all ... >axis parameters, they will not change. ... >> I have a chart that has the left side range from 0 - ... >> then go to Powerpoint to paste the picture it changes ...
    (microsoft.public.excel.charting)