Two labels on x-axis

  • Thread starter Thread starter Turnipboy
  • Start date Start date
T

Turnipboy

I have a bar chart of date of an order on the x-axis and cost of th
order on the y-axis, (each date in question is marked on the graph wit
its corresponding cost - it is not a linear time scale). How can I ge
the order number, which I have in a third column, to appear with th
date for each order:

Date___ Order No. Cost(£)
12.11.05 43251122 23
13.11.05 21391122 43

Thanks
 
Use the third column as data labels.

From Help:

You can quickly label all data points. Click the chart, click Chart Options
on the Chart menu, and then select the options you want on the Data Labels
tab.

HTH,
Bernie
MS Excel MVP
 
The options available only label the chart with the series name (whic
is just series1) or the date (which is already on the x-axis) or th
cost (which is already on the y-axis), I want to label the bars with
third series, i.e the order number
 
Do you know of another way by any chance, I can install that program on
this PC (work PC) or do the work on another PC and bring it to this
particular PC.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reversing Dates Sequence along X axis in a chart 3
How to draw a graph with the X axis as a time line of date. 4
Graph axis to change based on user input 1
Chart (scatter plot): values on X-axis. 1
align two y-axis 2
Horizontal axis to the bottom 1
Sr. Citizen Question On Adding A Trendline, Please ? 1
Unevenly spaced x axis on chart 1

Back
Top